PostgreSQL allows aggregates other than COUNT to accept * as the arugment.
Combined with the transformation of * -> 1 you get odd results from SELECT
MIN(*), MAX(*) FROM tab; instead of an error.
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2004-10-25 21:43:38|
|Subject: Re: aggregates other than count accpet * |
|Previous:||From: PostgreSQL Bugs List||Date: 2004-10-25 20:56:13|
|Subject: BUG #1294: Random errors (failed connection)|