Re: EXTRACT Clarification

From: Kris Jurka <books(at)ejurka(dot)com>
To: "Thomas F(dot)O'Connell" <tfo(at)sitening(dot)com>
Cc: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>, pgsql-docs(at)postgresql(dot)org
Subject: Re: EXTRACT Clarification
Date: 2004-09-29 13:25:59
Message-ID: Pine.BSO.4.56.0409290825020.14292@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-general

On Wed, 29 Sep 2004, Thomas F.O'Connell wrote:

> Note: EXTRACT is not a true function. SQL defines it as an expression
> that happens to look similar to a function call.
>
> Also, are there other expressions that fall into this category? I don't
> know the spec well enough to know.

At least COALESCE and NULLIF are not functions.

Kris Jurka

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Thomas F.O'Connell 2004-09-29 13:34:11 Re: EXTRACT Clarification
Previous Message Kris Jurka 2004-09-29 13:21:49 Add tablespace index entry

Browse pgsql-general by date

  From Date Subject
Next Message Thomas F.O'Connell 2004-09-29 13:34:11 Re: EXTRACT Clarification
Previous Message Thomas F.O'Connell 2004-09-29 12:35:32 EXTRACT Clarification