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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
