Re: return true / false instead of int4 value

--Thanks all (esp. doug, peter, stephan)

--works like a charm!

-X

-----Original Message-----
From: Stephan Szabo [mailto:sszabo@megazone23.bigpanda.com]

On Tue, 4 Jun 2002, Johnson, Shaunn wrote:

> Howdy:
>
> I want to know if this is even possible: How
> can I return a true/false value instead of
> integer?
>
> I want to do something like this:
>
> [snip]
>
> select count(*) from t_table
> having count(*) > 1500000
>
> [/snip]
>
> But want to return a true/false (bool) result.

Wouldn't select count(*)>1500000 from t_table;

give you a true/false based on whether the count
is greater than that number?