Postgres Pro
Downloads
Home   >   mailing lists

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

From Frank Bax
Subject Re: > and >= give the same result
Date
Msg-id 4EFC8465.10601@sympatico.ca
Whole thread Raw
In response to Re: > and >= give the same result  ("Jean-Yves F. Barbier" <12ukwn@gmail.com>)
Responses Re: > and >= give the same result
List pgsql-novice
Tree view 
On 12/29/11 09:29, 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?
>
> Well, I hoped '>' would have returned all rows beginning by 'z'
> and not any 'y'.


WHERE substr(note,0,1)>'y'

pgsql-novice by date:

Previous
From: Francisco Leovey
Date:
Subject: Re: Login role
Next
From: "Jean-Yves F. Barbier"
Date:
Subject: Re: > and >= give the same result