Postgres Pro
Downloads
Home   >   mailing lists

aggregates other than count accpet * - Mailing list pgsql-bugs

From Kris Jurka
Subject aggregates other than count accpet *
Date
Msg-id Pine.BSO.4.56.0410251621370.26148@leary.csoft.net
Whole thread Raw
Responses Re: aggregates other than count accpet *  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1294: Random errors (failed connection)
Next
From: Tom Lane
Date:
Subject: Re: aggregates other than count accpet *