Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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


pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group