dbTalk Databases Forums  

[BUGS] BUG #1516: DOC BUG: Interval type syntax and interval literal syntax

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #1516: DOC BUG: Interval type syntax and interval literal syntax in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Roy Badami
 
Posts: n/a

Default [BUGS] BUG #1516: DOC BUG: Interval type syntax and interval literal syntax - 03-04-2005 , 03:55 PM







The following bug has been logged online:

Bug reference: 1516
Logged by: Roy Badami
Email address: roy (AT) gnomon (DOT) org.uk
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

[@] 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 majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.