Re: comparing 2 queries

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