Postgres Pro
Downloads
Home   >   mailing lists

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

From Jean-Yves F. Barbier
Subject Re: > and >= give the same result
Date
Msg-id 20111229161940.00594e0d@anubis.defcon1
Whole thread Raw
In response to Re: > and >= give the same result  (Frank Bax <fbax@sympatico.ca>)
Responses Re: > and >= give the same result
List pgsql-novice
Tree view 
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%

--
Repartee is something we think of twenty-four hours too late.
        -- Mark Twain

pgsql-novice by date:

Previous
From: Frank Bax
Date:
Subject: Re: > and >= give the same result
Next
From: "Jean-Yves F. Barbier"
Date:
Subject: Re: > and >= give the same result