Re: EXTRACT Clarification

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 15:32:24
Message-ID: 29367.1096471944@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-general

"Thomas F.O'Connell" <tfo(at)sitening(dot)com> writes:
> I'm thinking something like this (with thanks to Stephan):

> Note: EXTRACT is not a true function. SQL defines it as an expression
> that happens to look similar to a function call.

Rather than documenting this, maybe we should change the grammar to
allow it?

regards, tom lane

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Stephan Szabo 2004-09-29 15:40:10 Re: EXTRACT Clarification
Previous Message Thomas F.O'Connell 2004-09-29 13:34:11 Re: EXTRACT Clarification

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Villa 2004-09-29 15:35:43 Converting to Java date example
Previous Message Stephan Szabo 2004-09-29 15:09:32 Re: Setting search paths inside a function (plpgsql)