Quick Links

Re: Patch for SQL-Standard Interval output and decoupling DateStyle from IntervalStyle

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
Cc:	Brendan Jurd <direvus(at)gmail(dot)com>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-hackers(at)postgresql(dot)org
Subject:	Re: Patch for SQL-Standard Interval output and decoupling DateStyle from IntervalStyle
Date:	2008-11-08 19:39:23
Message-ID:	20334.1226173163@sss.pgh.pa.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-hackers

BTW, I just noticed that CVS HEAD has a bug in reading negative SQL-spec
literals:

regression=# select interval '-2008-10';
interval
----------------------
-2008 years -10 mons
(1 row)

regression=# select interval '-0000-10';
interval
----------
10 mons
(1 row)

Surely the latter must mean -10 months. This is orthogonal to the
current patch ...

regards, tom lane

	From	Date	Subject
Next Message	Ron Mayer	2008-11-08 19:39:31	Re: Patch for SQL-Standard Interval output and decoupling DateStyle from IntervalStyle
Previous Message	Jeff Davis	2008-11-08 19:32:13	Re: auto_explain contrib moudle