Re: > and >= give the same result

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: > and >= give the same result
Date: 2011-12-29 15:16:53
Message-ID: 4EFC8465.10601@sympatico.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 12/29/11 09:29, Jean-Yves F. Barbier wrote:
> 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?
>
> Well, I hoped '>' would have returned all rows beginning by 'z'
> and not any 'y'.

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jean-Yves F. Barbier 2011-12-29 15:19:40 Re: > and >= give the same result
Previous Message Francisco Leovey 2011-12-29 15:06:01 Re: Login role