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
Kris Jurka <books@ejurka.com> writes:
PostgreSQL allows aggregates other than COUNT to accept * as the arugment.
This is not a bug, it's extensibility ;-)
regards, tom lane
