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 14:29:07
Message-ID: 20111229152907.17ff3791@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?

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Francisco Leovey 2011-12-29 15:06:01 Re: Login role
Previous Message Frank Bax 2011-12-29 13:48:37 Re: > and >= give the same result