[BUGS] aggregates other than count accpet * -
10-25-2004
, 04:33 PM
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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)
Re: [BUGS] aggregates other than count accpet * -
10-25-2004
, 04:46 PM
Kris Jurka <books (AT) ejurka (DOT) com> writes:
Quote:
PostgreSQL allows aggregates other than COUNT to accept * as the arugment.
This is not a bug, it's extensibility ;-)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)