Re: > and >= give the same result

On Thu, 29 Dec 2011 10:39:41 -0500
Frank Bax <fbax@sympatico.ca> wrote:

> > 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)

Do you mean that>'Y%' is taken as a literal and don't
develop as Y* (contrary to LIKE 'Y%')?

Meaning 'Y%' was for me: 'Yahoo', 'Ybsd', 'Ycommerce', 'Ymail', etc

--
Damn, I need a Coke!
        -- Dr. William DeVries
        [after implanting the first artificial human heart]