> and >= give the same result - Mailing list pgsql-novice

From Jean-Yves F. Barbier
Subject > and >= give the same result
Date
Msg-id 20111229141505.6a0cb9d7@anubis.defcon1
Whole thread Raw
Responses Re: > and >= give the same result
List 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 by date:

Previous
From: "Jean-Yves F. Barbier"
Date:
Subject: Re: LC_COLLATE UTF-8 Locales on Windows?
Next
From: "Mariana Damova"
Date:
Subject: Login role