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