sort order with < & > in varchar fields

Поиск
Список
Период
Сортировка
От Rolf Johansson
Тема sort order with < & > in varchar fields
Дата
Msg-id 7jhf2yfgbh.fsf@junk.nocrew.org
обсуждение исходный текст
Ответы Re: sort order with < & > in varchar fields
Список pgsql-sql
It is possible to extract rows in a table using
SELECT name FROM table WHERE name >= 'Bergman'.

The problem I have is that I get names like "Berg, Paul"
with this query, and I don't want that.

Is there documentation on how >= and <= works with varchar
fields? Does pg count in the "," character or ignore it?
And so on...

Version is 7.0.1.

/Rolf


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

Предыдущее
От: Kovacs Zoltan Sandor
Дата:
Сообщение: speed of recursive queries, 7.1
Следующее
От: Tom Lane
Дата:
Сообщение: Re: sort order with < & > in varchar fields