Michael Glaesemann <[EMAIL PROTECTED]> writes: > On Jan 4, 2007, at 13:33 , Tom Lane wrote: >> 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. Right, that's what convinced me not to use REVERSE. Also, the parallelism of this construct to what is allowed in ORDER BY seems a bit pleasing. > 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. Yup, I'd come to the same plan. Actually ASC will not be a complete noise word: if you specify it (or a NULLS clause) on an index type that doesn't have a sort order, you'll get an error. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly