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



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to