Re: > and >= give the same result

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: > and >= give the same result
Date: 2011-12-29 15:19:40
Message-ID: 20111229161940.00594e0d@anubis.defcon1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Thu, 29 Dec 2011 08:48:37 -0500
Frank Bax <fbax(at)sympatico(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jean-Yves F. Barbier 2011-12-29 15:30:44 Re: > and >= give the same result
Previous Message Frank Bax 2011-12-29 15:16:53 Re: > and >= give the same result