Re: EXTRACT Clarification - Mailing list pgsql-docs

From Stephan Szabo
Subject Re: EXTRACT Clarification
Date
Msg-id 20040929083745.L61021@megazone.bigpanda.com
Whole thread Raw
In response to Re: EXTRACT Clarification  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-docs
On Wed, 29 Sep 2004, Tom Lane wrote:

> "Thomas F.O'Connell" <tfo@sitening.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?

That would work, but presumably then we should be doing all the function
looking things, so probably CAST, EXTRACT, OVERLAY, POSITION, SUBSTRING,
TREAT, TRIM, CONVERT (and any, if any, that weren't in the section of the
grammar I saw those).

pgsql-docs by date:

Previous
From: Gourish Singbal
Date:
Subject: New User
Next
From: MX1@deloitte.com.au
Date:
Subject: Extension email attachment block