Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #1517: SQL interval syntax is accepted by the parser, - Mailing list pgsql-bugs

From Roy Badami
Subject Re: BUG #1517: SQL interval syntax is accepted by the parser,
Date
Msg-id 16961.61495.432114.693501@giles.gnomon.org.uk
Whole thread Raw
In response to Re: BUG #1517: SQL interval syntax is accepted by the parser,  (Roy Badami <roy@gnomon.org.uk>)
List pgsql-bugs
Tree view 
Roy> I have no objection to allowing things like

    Roy>    '1 hour 10 minutes' DAY TO SECOND

    Roy> but I'm just wondering whether the hybrid syntax is an
    Roy> unnecessary complication.

And furthermore, if you really want to allow constrained postgres
syntax interval literals (and I can't at the moment see how
constraining a literal is useful) then why *not* use the syntax Brian
suggested:

    INTERVAL DAY TO SECOND '1 hour 10 minutes'

This keeps the non-standard postgres syntax and the SQL standard
syntax nicely separate...

       -roy

pgsql-bugs by date:

Previous
From: Roy Badami
Date:
Subject: Re: BUG #1517: SQL interval syntax is accepted by the parser,
Next
From: Tom Lane
Date:
Subject: Re: Precision and scale of numeric column reported as value