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

>>>>> "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.