Re: Curious sorting puzzle

Поиск
Список
Период
Сортировка
От Ivan Voras
Тема Re: Curious sorting puzzle
Дата
Msg-id 44875B95.5000005@fer.hr
обсуждение исходный текст
Ответ на Re: Curious sorting puzzle  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Tom Lane wrote:

>>An ideal solution would be to have a
>>"not-locale-affected-varchar" field type :)
>
>
> If you're just storing ASCII then I think bytea might work for this.
> Do you need any actual text operations (like concatenation), or this
> just a store-and-retrieve field?

I've just tested bytea and it looks like a perfect solution - it supports:

- character-like syntax
- indexes
- uses indexes with LIKE 'x%' queries
- SUBSTRING()

That's good enough for us - it seems it's just what we need - a
string-like type with byte collation.

Thanks!

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: vacuuming problems continued
Следующее
От: "soni de"
Дата:
Сообщение: Re: Regarding ALTER Command