Обсуждение: Table name used as aggregate argument

Поиск
Список
Период
Сортировка

Table name used as aggregate argument

От
Dennis Bjorklund
Дата:
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

Re: Table name used as aggregate argument

От
Tom Lane
Дата:
Dennis Bjorklund <db@zigo.dhs.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