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

On 12/29/11 10:19, Jean-Yves F. Barbier wrote:
> On Thu, 29 Dec 2011 08:48:37 -0500
> Frank Bax<fbax@sympatico.ca>  wrote:
>
>>
>> The string 'y%' is greater than 'y'! Therefore, both queries will return
>> y% and z% - where is the problem?
>
> Oops, I'm read too fast; but it dont change my PB:
> SELECT * FROM table WHERE col>  'Y%' still returns y%&  Y%
>

NO.  It does not.

create table barbier (col varchar);
insert into barbier values ('y%');
insert into barbier values ('z%');
insert into barbier values ('Y%');
  select * from barbier where col>'Y%';
  col
-----
  y%
  z%
(2 rows)