Re: EXTRACT Clarification

Ah, so it's really a question of whether the syntactic sugar of CREATE
INDEX is considered worthwhile by the developers (rather than a
standards compliance issue) because CREATE INDEX is not a part of the
SQL spec?

Now that I understand what's going on, I don't have a strong
preference, but I'd say that either it needs noting in the
documentation or it should be added to the grammar.

And if it isn't going to hit the grammar for 7.4.x, I'd be happy to
supply a doc patch.

-tfo

On Sep 29, 2004, at 12:09 PM, Tom Lane wrote:

> "Thomas F. O'Connell" <tfo(at)sitening(dot)com> writes:
>> That seems reasonable, too, although I was interested to learn that
>> this (and a few other expressions) weren't actually functions.
>
> They are functions ... but not from the point of view of the grammar,
> which has special productions for them to cope with SQL's whimsical
> syntax requirements.
>
> regards, tom lane