Postgres Pro
Downloads
Home   >   mailing lists

Re: Create an index with a sort condition - Mailing list pgsql-general

From Tom Lane
Subject Re: Create an index with a sort condition
Date
Msg-id 13279.1144129252@sss.pgh.pa.us
Whole thread Raw
In response to Re: Create an index with a sort condition  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Create an index with a sort condition  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Tree view 
Martijn van Oosterhout <kleptog@svana.org> writes:
> [ Q about reverse-sort opclasses ]

> Well, if COLLATE support ever gets done, it'll fix this too and be SQL
> compliant to boot.

I keep having a nagging feeling that COLLATE is a completely
inappropriate way to deal with reverse-sort semantics for non-textual
datatypes.  Still waiting to see this patch ...

            regards, tom lane

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Create an index with a sort condition
Next
From: "Thomas F. O'Connell"
Date:
Subject: CREATE TABLE (with INHERITS) and ACCESS EXCLUSIVE locks