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

Reply via email to