Re: Proposed patch: make SQL interval-literal syntax work per spec

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Proposed patch: make SQL interval-literal syntax work per spec
Date: 2008-09-12 21:04:38
Message-ID: 48CAD966.7030605@cheapcomplexdevices.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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'?

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Lawrence, Ramon 2008-09-12 22:27:00 Re: Potential Join Performance Issue
Previous Message Ron Mayer 2008-09-12 20:55:10 Re: Proposed patch: make SQL interval-literal syntax work per spec