"Thomas F. O'Connell" <tfo@sitening.com> writes:
> 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?
Right. It is not a SQL-compliance item because CREATE INDEX isn't in
the standard in the first place.
The fact that the CREATE INDEX syntax allows for some things that look
like function calls but not for other things that look like function
calls is an annoyance, no doubt about it. I'm not sure how important
it is to fix though.
regards, tom lane