aggregates other than count accpet *

From: Kris Jurka <books(at)ejurka(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: aggregates other than count accpet *
Date: 2004-10-25 21:25:15
Message-ID: Pine.BSO.4.56.0410251621370.26148@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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.

Kris Jurka

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-10-25 21:43:38 Re: aggregates other than count accpet *
Previous Message PostgreSQL Bugs List 2004-10-25 20:56:13 BUG #1294: Random errors (failed connection)