| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: BOOLEAN question |
| Date: | 2002-10-29 22:19:55 |
| Message-ID: | Pine.LNX.4.44.0210291849280.2006-100000@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gmx(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James Adams | 2002-10-29 22:37:46 | Selecting * from the base table but getting the inheriteds columns |
| Previous Message | Josh Berkus | 2002-10-29 20:32:02 | Re: BOOLEAN question |