state_demo2=# select * from subtest_registration where sid='823000046';
                  id                  |    sid    |              subtest_id              |        create_date         |       modified_date
--------------------------------------+-----------+--------------------------------------+----------------------------+----------------------------
 0016a22e-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e696b230-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:42.519937 | 2011-02-14 13:02:42.519937
 00191e6e-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6982d22-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:42.535749 | 2011-02-14 13:02:42.535749
 001b7cf4-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6994f9a-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:42.551412 | 2011-02-14 13:02:42.551412
 001df056-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e69a7f8c-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:42.567453 | 2011-02-14 13:02:42.567453
 0020702e-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e69b9674-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:42.583886 | 2011-02-14 13:02:42.583886
 0023631a-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e69cb7b6-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:42.604121 | 2011-02-14 13:02:42.604121
 002601b0-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e69dbdaa-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:42.620261 | 2011-02-14 13:02:42.620261
 00286e50-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e69ef03a-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:42.636202 | 2011-02-14 13:02:42.636202
 002ae360-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6a02c8e-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:42.652446 | 2011-02-14 13:02:42.652446
 002d4d62-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6a129cc-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:42.668169 | 2011-02-14 13:02:42.668169
 002fc8bc-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6a23a38-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:42.684427 | 2011-02-14 13:02:42.684427
 00323c50-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6a35a58-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:42.700497 | 2011-02-14 13:02:42.700497
 0034eaf4-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6a48680-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:42.730117 | 2011-02-14 13:02:42.730117
 003b10aa-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6a5bf8c-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:42.758167 | 2011-02-14 13:02:42.758167
 003e08c8-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6a6e268-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:42.777621 | 2011-02-14 13:02:42.777621
 00410294-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6a7e8ca-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:42.826942 | 2011-02-14 13:02:42.826942
 0048cde4-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6a91de4-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:42.902443 | 2011-02-14 13:02:42.902443
 0053944a-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6aa3b02-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:42.918793 | 2011-02-14 13:02:42.918793
 0056041e-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6ab4f92-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:42.934889 | 2011-02-14 13:02:42.934889
 00586588-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6ac5acc-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:42.950592 | 2011-02-14 13:02:42.950592
 005ac774-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6ad6318-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:42.965934 | 2011-02-14 13:02:42.965934
 005d304a-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6ae8cfc-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:42.981981 | 2011-02-14 13:02:42.981981
 005f97e0-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6af8ff8-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:42.99774  | 2011-02-14 13:02:42.99774
 00620016-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6b09952-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:43.013492 | 2011-02-14 13:02:43.013492
 0064300c-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6b1a19e-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:43.027828 | 2011-02-14 13:02:43.027828
 00667f06-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6b2caec-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:43.042966 | 2011-02-14 13:02:43.042966
 0068aa06-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6b3d61c-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:43.057148 | 2011-02-14 13:02:43.057148
 006ad3a8-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6b50b22-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:43.071376 | 2011-02-14 13:02:43.071376
 006d1622-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6b63916-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:43.086162 | 2011-02-14 13:02:43.086162
 006f36dc-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6b73050-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:43.100105 | 2011-02-14 13:02:43.100105
 0071a6c4-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6b84e72-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:43.1161   | 2011-02-14 13:02:43.1161
 007428cc-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6b97e82-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:43.132302 | 2011-02-14 13:02:43.132302
 007689be-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6ba7e68-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:43.148109 | 2011-02-14 13:02:43.148109
 0078f4b0-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6bba6bc-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:43.163993 | 2011-02-14 13:02:43.163993
 007b6f4c-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6bcd6cc-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:43.180066 | 2011-02-14 13:02:43.180066
 007dec2c-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6bde206-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:43.196541 | 2011-02-14 13:02:43.196541
 00806ac4-386d-11e0-b6cc-60f64591c4a2 | 823000046 | e6bf0ac8-10e0-11df-80f4-1a7fbecf21f7 | 2011-02-14 13:02:43.212721 | 2011-02-14 13:02:43.212721
(37 rows)