Re: Proposed patch: make SQL interval-literal syntax work per spec - Mailing list pgsql-hackers

From Ron Mayer
Subject Re: Proposed patch: make SQL interval-literal syntax work per spec
Date
Msg-id 48CAD966.7030605@cheapcomplexdevices.com
Whole thread Raw
In response to Re: Proposed patch: make SQL interval-literal syntax work per spec  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
List pgsql-hackers
Ron Mayer wrote:
> Tom Lane wrote:
>> you need is 'yyy-mm dd hh:mm:ss' where you omit yyy-mm if
>> zeroes, omit dd if zero, omit hh:mm:ss if zeroes (but maybe
>> only if dd is also 0?  otherwise your output is just dd which
>> is uncomfortably ambiguous).

Oh, and if both parts are 0, I guess we desire
the (more comfortable than the alternatives) '0'?


pgsql-hackers by date:

Previous
From: Ron Mayer
Date:
Subject: Re: Proposed patch: make SQL interval-literal syntax work per spec
Next
From: "Lawrence, Ramon"
Date:
Subject: Re: Potential Join Performance Issue