> and >= give the same result

Поиск
Список
Период
Сортировка
От Jean-Yves F. Barbier
Тема > and >= give the same result
Дата
Msg-id 20111229141505.6a0cb9d7@anubis.defcon1
обсуждение исходный текст
Ответы Re: > and >= give the same result  (Frank Bax <fbax@sympatico.ca>)
Список pgsql-novice
Hi list,

I'm trying to help a friend with his queries and I've something
strange (well, to me:):

SELECT * FROM tb1 WHERE note > 'y';

returns the *same* result as:

SELECT * FROM tb1 WHERE note >= 'y';

There's something wrong: I though I'd have:
1st qry: z%
2nd qry: y% and z%

What is wrong with using '>' &| '>=' with strings?

I also know there's a page talking about that in the docs, but I
can't find it.

JY
--
Help Stamp Out Rape!  (Say Yes.)

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

Предыдущее
От: "Jean-Yves F. Barbier"
Дата:
Сообщение: Re: LC_COLLATE UTF-8 Locales on Windows?
Следующее
От: "Mariana Damova"
Дата:
Сообщение: Login role