OK, do we want to put back the mention of these in the release notes? The non-zulu ones sound pretty strange to me and might be better left undocumented.
--------------------------------------------------------------------------- Marcus B?rger wrote: > Hello Christopher, > > Wednesday, October 22, 2003, 10:21:02 AM, you wrote: > > >>>What in the heck is 'zulu', 'allballs' or 'z'??? > >> > >> > >> 'allballs' probably alludes to the visual appearance of '00:00:00'. 'z' > >> and 'zulu' should be time zones equivalent (or similar?) to UTC or GMT > >> ((US?) military jargon). > > > But they don't work... > > Only the combination of both doesn't work: > template1=# select 'allballs'::timetz; > timetz > ------------- > 00:00:00+00 > (1 row) > > template1=# select '0:0:0 z'::timetz; > timetz > ------------- > 00:00:00+00 > (1 row) > > template1=# select '0:0:0 zulu'::timetz; > timetz > ------------- > 00:00:00+00 > (1 row) > > template1=# select 'allballs'::timetz; > timetz > ------------- > 00:00:00+00 > (1 row) > > template1=# select 'allballs z'::timetz; > ERROR: Bad time external representation 'allballs z' > template1=# select 'allballs zulu'::timetz; > ERROR: Bad time external representation 'allballs zulu' > > Your problem is using 'time' which doesn't know time zones. > > -- > Best regards, > Marcus mailto:[EMAIL PROTECTED] > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
