On Wed, 5 Jan 2005, Mage wrote:
> "order by a asc b desc"
>
> how can I create an index for this?
You need to create an operator class for reversed comparison of whatever
type b is and then use it on b in the index definition.
Something like (however, you should really use a C function for the
On Wed, Jan 05, 2005 at 15:35:22 +0100,
Mage <[EMAIL PROTECTED]> wrote:
> Hello,
>
> "order by a asc b desc"
>
> how can I create an index for this?
Currently you can't directly.
In recent versions of Postgres you have some options:
If one of the types has a normal minus operator, then
Hello,
"order by a asc b desc"
how can I create an index for this?
Mage
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
