From: Richard Huxton <dev@archonet.com>
To: Martin Marques <martin@bugs.unl.edu.ar>
To: pgsql-sql@postgresql.org
Subject: Re: comparing 2 queries
Date: Thu, 15 May 2003 15:56:15 +0100
Message-ID: <200305151556.15716.dev@archonet.com> (raw)
In-Reply-To: <200305151048.20609.martin@bugs.unl.edu.ar>
References: <200305151048.20609.martin@bugs.unl.edu.ar>
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 (note
the brackets around the sub-selects and the fact they've been aliased).
=# SELECT (a.value1=b.value2) FROM (SELECT 100 as value1) as a, (SELECT 200 as
value2) as b;
?column?
----------
f
(1 row)
=# SELECT (a.value1=b.value2) FROM (SELECT 200 as value1) as a, (SELECT 200 as
value2) as b;
?column?
----------
t
(1 row)
--
Richard Huxton
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: dev@archonet.com, martin@bugs.unl.edu.ar
Subject: Re: comparing 2 queries
In-Reply-To: <200305151556.15716.dev@archonet.com>
* 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