Roy Badami wrote:
> >>>>> "Bruce" == Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> >> You also need to make EXTRACT do the right thing.
> >> eg EXTRACT (MONTH FROM INTERVAL '1-1' YEAR TO MONTH) => 1
> >> but
> >> EXTRACT (MONTH FROM INTERVAL '13' MONTH) => 13
> >> Ditto for day-time intervals, of course.
> Bruce> Uh, I think this already works fine for PG syntax, and I
> Bruce> assume once we support ANSI syntax it will work fine too:
> Ok, so based on Tom's comments it sounds like this isn't a non-issue;
> in fact it sounds like it will be very hard to make this work (at
> least without changing the internal represnation of an interval).
> So perhaps there should be something on the TODO list, even if only:
> o figure out whether it is feasible to make EXTRACT obey ISO
> standard semantics.
I am thinking it isn't worth following the spec in this case.
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
In response to
pgsql-bugs by date
|Next:||From: Andrew - Supernews||Date: 2005-03-24 09:14:25|
|Subject: Re: BUG #1552: massive performance hit between 7.4 and 8.0.1|
|Previous:||From: Bruce Momjian||Date: 2005-03-24 03:39:27|
|Subject: Re: BUG #1517: SQL interval syntax is accepted by the parser,|