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
