Re: order by, for custom types

Поиск
Список
Период
Сортировка
От Grzegorz Jaskiewicz
Тема Re: order by, for custom types
Дата
Msg-id 51E9BC86-5CD2-4060-A747-8EF1FC8DED4E@pointblue.com.pl
обсуждение исходный текст
Ответ на Re: order by, for custom types  (Martijn van Oosterhout <kleptog@svana.org>)
Ответы Re: order by, for custom types  (Martijn van Oosterhout <kleptog@svana.org>)
Список 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 по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Practical error logging for very large COPY
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: order by, for custom types