Dennis Bjorklund <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
