"Thomas Yagel" <[EMAIL PROTECTED]> writes:
> Right now the index that I have on timestamp is not used because the Primary
> Key(ID) index is chosen for ordering. If I place a multicolumn index on
> (timestamp, id) will that index be able to filter the timestamp and still be
> used for returning th
I have a situtation where a particular table includes a timestamp column and
a id column. The query I am working with right now filters based on
timestamp and orders based on ID.
I have not found enough information about how multicolumn indexes actually
work to determine if one will help me in th
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
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
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:
