Re: order by, for custom types

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