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

Roy Badami wrote:
> >>>>> "Bruce" == Bruce Momjian <pgman@candle.pha.pa.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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073