> Markus Bertheau writes:
>
> > I wonder about the difference between date_part('week', ...) and
> > extract(week from ...) not only but also from a performance point of
> > view. I read extract is standard and date_part is not. Backwards
> > compatibility maybe justifies the existence of date_part. Whats else?
>
> I think date_part() was adapted from Ingres. Btw., note that the "week"
> parameter (and most others) aren't standard either.
Yes, from Ingres. I think Thomas added it. Both he and I have Ingres
experience.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026