Re: Reverse-sort indexes and NULLS FIRST/LAST sorting

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