Home > mailing lists

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

From	Doug Fields
Subject	Re: return true / false instead of int4 value
Date	June 4, 2002 15:25:22
Msg-id	5.1.0.14.2.20020604121814.02c4b1e0@pop.pexicom.com Whole thread Raw
In response to	return true / false instead of int4 value ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
List	pgsql-general

select count(*) from t_table
having count(*) > 1500000

[/snip]

But want to return a true/false (bool) result.

Off the top of my head:

select count > 1500000 from (select count(*) as count from t_table) as a;

Doug

From: Stephan Szabo
Date: 04 June 2002, 15:18:29
Subject: Re: return true / false instead of int4 value

From: "Peter Darley"
Date: 04 June 2002, 15:25:23
Subject: Re: return true / false instead of int4 value