Content-Type: text/plain;
  charset="iso-8859-1"
From: Richard Huxton <dev@archonet.com>
Organization: Archonet Ltd
To: Martin Marques <martin@bugs.unl.edu.ar>, pgsql-sql@postgresql.org
Subject: Re: comparing 2 queries
Date: Thu, 15 May 2003 15:56:15 +0100
User-Agent: KMail/1.4.3
References: <200305151048.20609.martin@bugs.unl.edu.ar>
In-Reply-To: <200305151048.20609.martin@bugs.unl.edu.ar>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200305151556.15716.dev@archonet.com>

On Thursday 15 May 2003 2:48 pm, Martin Marques wrote:
> I have to queries that return INT values, and I want to know if one is
> less or equal to the other.
> Is it posible to put it all in one query and have a return of 1 or 0?
> I tried somethings with CASE, but it didn't work.

Assuming each query returns only one row, something like the following (not=
e=20
the brackets around the sub-selects and the fact they've been aliased).

=3D# SELECT (a.value1=3Db.value2) FROM (SELECT 100 as value1) as a, (SELECT=
 200 as=20
value2) as b;
 ?column?
----------
 f
(1 row)

=3D# SELECT (a.value1=3Db.value2) FROM (SELECT 200 as value1) as a, (SELECT=
 200 as=20
value2) as b;
 ?column?
----------
 t
(1 row)

--=20
  Richard Huxton