| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Timestamp docs weirdness |
| Date: | 2003-10-22 07:21:23 |
| Message-ID: | 3F962FF3.4070900@familyhealth.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
What does this in the date/time type docs mean?
zulu, allballs, z time 00:00:00.00 UTC
Cos it has bizarro behaviour:
In 7.3.4:
australia=# select 'zulu'::time;
ERROR: Bad time external representation 'zulu'
australia=# select 'allballs'::time;
time
----------
00:00:00
(1 row)
australia=# select 'z'::time;
ERROR: Bad time external representation 'z'
australia=# select 'zulu, allballs, z'::time;
ERROR: Bad time external representation 'zulu, allballs, z'
australia=#
Virtually identical behaviour in 7.4b4.
What in the heck is 'zulu', 'allballs' or 'z'???
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2003-10-22 07:39:11 | Re: [HACKERS] obj_description problems? |
| Previous Message | Neil Conway | 2003-10-22 06:37:57 | Re: 7.4 compatibility question |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2003-10-22 07:39:11 | Re: [HACKERS] obj_description problems? |
| Previous Message | Neil Conway | 2003-10-22 06:24:03 | more improvements to release notes |