Re: select fails on indexed varchars.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: select fails on indexed varchars.
Дата
Msg-id 26252.980819089@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: select fails on indexed varchars.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
> links=# select * from foo where a < 'Test0'::bpchar;
>  a
> ---
> (0 rows)

> links=#

> Are you saying the second test should have returned true under C locale?

Yes.  You are not really in C locale, or at least your postmaster isn't.
This looks like ISO sorting rules to me --- perhaps you are in en_US
locale.

> Is this a version dependant bug? Will downgrading to 6.x get me going?

No.  Fix your locale.  I'm afraid I don't have any more advice to offer
on that than I gave already ...

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Problem with inet/cidr convert functions
Следующее
От: Peter Mount
Дата:
Сообщение: Re: [JDBC] no way in LargeObject API to detect short read?