Re: order by, for custom types - Mailing list pgsql-hackers

From Grzegorz Jaskiewicz
Subject Re: order by, for custom types
Date
Msg-id 51E9BC86-5CD2-4060-A747-8EF1FC8DED4E@pointblue.com.pl
Whole thread Raw
In response to Re: order by, for custom types  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: order by, for custom types  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers
On 2005-11-22, at 16:39, Martijn van Oosterhout wrote:

> On Tue, Nov 22, 2005 at 04:24:21PM +0100, Grzegorz Jaskiewicz wrote:
>>> Translation: you do know how to define a sortable order (ie,  
>>> generate
>>> the text version and compare); you're just too lazy to create the
>>> operators to do it ...
>> We do have WORKING < , > , etc operators, and ::text cast already.
>> Thing is, can I have btree and gist indexes at the same time ?
>
> Sure, did you look at the ltree example someone pointed you to?
>
> Have a nice day,
Ok, I hacked btree for my type, and surely I can have both btree and  
gist at the same time on the same column.
/me is now going to have a look on btree_gist.

Thanks folks.

-- 
GJ

"If we knew what we were doing, it wouldn't be called Research, would  
it?" - AE





pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Practical error logging for very large COPY
Next
From: Martijn van Oosterhout
Date:
Subject: Re: order by, for custom types