On Jan 4, 2007, at 13:33 , Tom Lane wrote:
> Another possible objection is that in the proposed CREATE INDEX syntax
>
> index-column-id [ opclass-name ] [ DESC ] [ NULLS {FIRST|LAST} ]
>
> DESC must be a fully reserved word else it can't be distinguished from
> an opclass name. But guess what, it already is.
A point in favor of using DESC over REVERSE as you had earlier
proposed is that DESC is already a reserved word, while REVERSE isnt'
even in the list of key words. As DESC is quite closely associated
with its antonym ASC wrt ordering, any thoughts of allowing ASC as an
optional noise word? Users may be surprised if ASC were to throw an
error.
Michael Glaesemann
grzm seespotcode net