On 12/29/11 08:15, Jean-Yves F. Barbier wrote:
> 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.
The string 'y%' is greater than 'y'! Therefore, both queries will return
y% and z% - where is the problem?
In response to
pgsql-novice by date
|Next:||From: Jean-Yves F. Barbier||Date: 2011-12-29 14:29:07|
|Subject: Re: > and >= give the same result|
|Previous:||From: Jean-Yves F. Barbier||Date: 2011-12-29 13:15:05|
|Subject: > and >= give the same result|