Re: [GENERAL] Multicolumn indexes and ORDER BY

2004-06-16 Thread Tom Lane
Jernej Kos <[EMAIL PROTECTED]> writes: > Well, writing a C function is not a problem ;) So where could i find any > documentation regarding this matter ? Read the "Interfacing Extensions To Indexes" docs chapter. A crude example for integers would go like regression=# create function revcmp(int

Re: [GENERAL] Multicolumn indexes and ORDER BY

2004-06-16 Thread Tom Lane
Jernej Kos <[EMAIL PROTECTED]> writes: > Yes i tried that already - and as you said, it works. But i need to have one > column sorted DESC and one ASC. Is there any way this could be done ? Not easily. You could look into building a "reverse sort" operator class for one index column or the other

Re: [GENERAL] Multicolumn indexes and ORDER BY

2004-06-16 Thread Jernej Kos
Yes i tried that already - and as you said, it works. But i need to have one column sorted DESC and one ASC. Is there any way this could be done ? Regards, Jernej Kos. On Wednesday 16 of June 2004 08:12, Martijn van Oosterhout wrote: > On Wed, Jun 16, 2004 at 07:12:26AM +0200, Jernej Kos wrote: