Re: count syntax

Is this a TODO bug?

---------------------------------------------------------------------------

Tom Lane wrote:
> Patrick Welche <prlw1@newn.cam.ac.uk> writes:
> > What is the difference between the following?
>
> > transatlantic=# select count(*) from trans;
>
> This is a SQL-spec-mandated special case meaning "count the number of rows".
>
> > transatlantic=# select count(trans.flowindex) from trans;
>
> This counts the number of non-null values of trans.flowindex.  Also
> per spec.
>
> > transatlantic=# select count(trans.*) from trans;
> ERROR:  Memory exhausted in AllocSetAlloc(204)
>
> This syntax is not legal per SQL spec.  Postgres interprets it as a
> command to count the number of non-null values of "trans.*", which in
> this context is taken as being a whole-row variable.  Unfortunately the
> present implementation of whole-row variables leaks memory ...
>
> I don't believe that a whole-row variable will ever be null, so the
> end result is the same as count(*).  You may as well spell it in the
> spec-approved fashion.
>
>             regards, tom lane
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073