Postgres Pro
Downloads
Home   >   mailing lists

Re: Patch for SQL-Standard Interval output and decoupling DateStyle from IntervalStyle - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Patch for SQL-Standard Interval output and decoupling DateStyle from IntervalStyle
Date
Msg-id 29449.1226192433@sss.pgh.pa.us
Whole thread Raw
In response to Re: Patch for SQL-Standard Interval output and decoupling DateStyle from IntervalStyle  (Chuck McDevitt <cmcdevitt@greenplum.com>)
List pgsql-hackers
Tree view 
Chuck McDevitt <cmcdevitt@greenplum.com> writes:
> Doesn't ANSI standard interval syntax have the minus sign before the quotes?
> Select interval -'2008-10';

They allow it either there or inside the quotes.

We can't support outside-the-quotes unless we make INTERVAL a fully
reserved word (and even then there are syntactic problems :-().

Putting the minus sign before INTERVAL works fine btw ...
        regards, tom lane

pgsql-hackers by date:

Previous
From: Chuck McDevitt
Date:
Subject: Re: Patch for SQL-Standard Interval output and decoupling DateStyle from IntervalStyle
Next
From: Tom Lane
Date:
Subject: Re: WIP: Page space reservation (pgupgrade)