Re: EXTRACT Clarification

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).