Unix Technical Forum

BUG #1516: DOC BUG: Interval type syntax and interval literal syntax

This is a discussion on BUG #1516: DOC BUG: Interval type syntax and interval literal syntax within the pgsql Bugs forums, part of the PostgreSQL category; --> The following bug has been logged online: Bug reference: 1516 Logged by: Roy Badami Email address: roy@gnomon.org.uk PostgreSQL version: ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Bugs

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-10-2008, 09:37 AM
Roy Badami
 
Posts: n/a
Default BUG #1516: DOC BUG: Interval type syntax and interval literal syntax


The following bug has been logged online:

Bug reference: 1516
Logged by: Roy Badami
Email address: roy@gnomon.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@postgresql.org so that your
message can get through to the mailing list cleanly

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
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
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 01:01 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com