Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 4B6EF47672A for ; Mon, 28 Oct 2002 20:30:04 -0500 (EST) Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (Postfix) with ESMTP id 06C76476715 for ; Mon, 28 Oct 2002 20:30:03 -0500 (EST) Received: from [66.219.92.2] (HELO chocolate-mousse) by davinci.ethosmedia.com (CommuniGate Pro SMTP 3.5.9) with ESMTP id 1802938; Mon, 28 Oct 2002 17:31:57 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: Stephan Szabo Subject: Re: BOOLEAN question Date: Mon, 28 Oct 2002 18:29:35 -0700 X-Mailer: KMail [version 1.4] Cc: References: <20021028172506.G86039-100000@megazone23.bigpanda.com> In-Reply-To: <20021028172506.G86039-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200210281729.35967.josh@agliodbs.com> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/386 X-Sequence-Number: 10103 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)=3D1 Good, I'm not just brain-dead. I did figure out another way to do it, but= if=20 I wrote a MAX(bool), what are the chances it would get added to the core? = I=20 don't see any good reason not to have one. --=20 -Josh Berkus Aglio Database Solutions San Francisco