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?

--
/Dennis Björklund


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Dennis Bjorklund <db (AT) zigo (DOT) dhs.org> writes:
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