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 по дате отправления: