The following bug has been logged online:
Bug reference: 1516
Logged by: Roy Badami
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system: Solaris 9
Description: DOC BUG: Interval type syntax and interval literal
syntax
Details:
Interval types
--------------
8.5 of the manual gives the syntax of the interval type as
interval [ (p) ]
However PostgreSQL seems to support more of the SQL standard syntax than
this... eg the following type is not accepted in CREATE TABLE, but is
clearly stored as distinct from an unadorned interval type, since it is
echoed back unchanged by \d
interval year to month
The complete SQL syntax isn't supported, however, eg the following is
rejected by the parser:
internal month(3)
Interval literals
-----------------
8.5.1.4 of the manual gives the syntax for interval literals as
[EMAIL PROTECTED] quantity unit [quantity unit...] [direction]
and then comments:
The optional precision p should be between 0 and 6, and defaults to the
precision of the input literal.
But the specified syntax doesn't include a precision p.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
