Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org> writes:
> How come this work in pg (8.0 and older):
> CREATE TABLE bug (x int);
> SELECT count(bug) FROM bug;
> Shouldn't it complain and say that "bug" is not a column?
No. This is a perfectly good, if somewhat historical, spelling of
SELECT count(bug.*) FROM bug;
Since count() takes any data type at all, a record type is just as
good as anything else...
regards, tom lane