From: Ragnar Hafstað <gnari@simnet.is>
To: tjo@acm.org
Cc: pgsql-sql@postgresql.org
Subject: Re: 9.17.5. Row-wise Comparison
Date: Thu, 07 Apr 2005 15:51:54 +0000
Message-ID: <1112889114.5742.17.camel@localhost.localdomain> (raw)
In-Reply-To: <42553936.2010108@acm.org>
References: <200504032037.j33Kb1kh016358@hosting.commandprompt.com>
<4254AD87.2030508@acm.org>
<13655.1112849262@sss.pgh.pa.us>
<42553936.2010108@acm.org>
On Thu, 2005-04-07 at 06:44 -0700, TJ O'Donnell wrote:
> it might break in future.
>
> > if (b > 1) then true
> > else if (b = 1 and c > 2) then true
> > else if (b = 1 and c = 2 and d > 3) then true
> > else false
> Your spec sql snippet is like an OR, isn't it, instead
> of an AND as I'm reyling on?
not really.
> After PG is to spec, will the behaviour I now see change?
yes
> > "TJ O'Donnell" <tjo@acm.org> writes:
> >
> >>I've been using syntax like
> >>select a from tbl where (b,c,d) > (1,2,3)
> >> to mean
> >>select a from t where b>1 and b>2 and d>3
if b=2, c=1 and d=1 then the expression
(b,c,d) > (1,2,3)
currently evaluates to false, but according to spec,
should evaluate to true.
gnari
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gnari@simnet.is, tjo@acm.org
Subject: Re: 9.17.5. Row-wise Comparison
In-Reply-To: <1112889114.5742.17.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox