date_part vs extract - Mailing list pgsql-sql

From Markus Bertheau
Subject date_part vs extract
Date
Msg-id 1007023539.4636.66.camel@entwicklung01.cenes.de
Whole thread Raw
Responses Re: date_part vs extract  (Brent Verner <brent@rcfile.org>)
Re: date_part vs extract  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-sql
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?

Markus Bertheau

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: PL/pgSQL loops?
Next
From: Brent Verner
Date:
Subject: Re: date_part vs extract