Re: BUG #1518: Conversions to (undocumented) SQL year-month and

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