date_part vs extract

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: postgres sql list <pgsql-sql(at)postgresql(dot)org>
Subject: date_part vs extract
Date: 2001-11-29 08:45:38
Message-ID: 1007023539.4636.66.camel@entwicklung01.cenes.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Brent Verner 2001-11-29 09:48:39 Re: date_part vs extract
Previous Message Tom Lane 2001-11-29 06:15:08 Re: Return Opaque / Error in Function