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 20111229152907.17ff3791@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?

Well, I hoped '>' would have returned all rows beginning by 'z'
and not any 'y'.

--
Love sometimes expresses itself in sacrifice.
        -- Kirk, "Metamorphosis", stardate 3220.3

pgsql-novice by date:

Previous
From: Frank Bax
Date:
Subject: Re: > and >= give the same result
Next
From: Francisco Leovey
Date:
Subject: Re: Login role