Re: return true / false instead of int4 value - Mailing list pgsql-general

From Stephan Szabo
Subject Re: return true / false instead of int4 value
Date
Msg-id 20020604091705.X3265-100000@megazone23.bigpanda.com
Whole thread Raw
In response to return true / false instead of int4 value  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
List pgsql-general
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?


pgsql-general by date:

Previous
From: "Johnson, Shaunn"
Date:
Subject: return true / false instead of int4 value
Next
From: Doug Fields
Date:
Subject: Re: return true / false instead of int4 value