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:mail@marcus-boerger.de
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073