Re: BOOLEAN question - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: BOOLEAN question
Date
Msg-id Pine.LNX.4.44.0210291849280.2006-100000@localhost.localdomain
Whole thread Raw
In response to Re: BOOLEAN question  (Josh Berkus <josh@agliodbs.com>)
Responses Re: BOOLEAN question
List pgsql-sql
Josh Berkus writes:

> 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.

One reason not to have one is that Boolean values are not naturally
ordered, so a maximum doesn't exist.  (Yes, I know there are comparison
operators defined for boolean, but that doesn't make it right.)

What seems more reasonable is to define conjuntion and disjunction
aggregates, which would mostly do the same thing but their semantics
wouldn't be as controversial.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: BOOLEAN question
Next
From: "James Adams"
Date:
Subject: Selecting * from the base table but getting the inheriteds columns