Timestamp docs weirdness - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Timestamp docs weirdness
Date
Msg-id 3F962FF3.4070900@familyhealth.com.au
Whole thread Raw
Responses Re: Timestamp docs weirdness  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
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






pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: 7.4 compatibility question
Next
From: Christopher Kings-Lynne
Date:
Subject: integer ceiling in LIMIT and OFFSET