Re: BOOLEAN question - Mailing list pgsql-sql

From Josh Berkus
Subject Re: BOOLEAN question
Date
Msg-id 200210281729.35967.josh@agliodbs.com
Whole thread Raw
In response to Re: BOOLEAN question  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: BOOLEAN question
Re: BOOLEAN question
List pgsql-sql
Stephan,

> Well, you might be better off making a max(bool), but a not
> super-efficient version might be:
>  max(case when col then 1 else 0 end)=1

Good, I'm not just brain-dead.   I did figure out another way to do it, but if
I wrote a MAX(bool), what are the chances it would get added to the core?   I
don't see any good reason not to have one.

--
-Josh BerkusAglio Database SolutionsSan Francisco



pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: BOOLEAN question
Next
From: Stephan Szabo
Date:
Subject: Re: BOOLEAN question