Re: count syntax

On Fri, Apr 11, 2003 at 12:44:38 +0100,
  Patrick Welche <prlw1@newn.cam.ac.uk> wrote:
> What is the difference between the following?
>
> transatlantic=# select count(*) from trans;
>  count
> --------
>  453602
> (1 row)

The above counts all rows.

>
> transatlantic=# select count(trans.flowindex) from trans;
>  count
> --------
>  453602
> (1 row)

The above counts all rows where trans.flowindex is not null.

>
> transatlantic=# select count(trans.*) from trans;
> ERROR:  Memory exhausted in AllocSetAlloc(204)

I don't know why you got an error here.

>
> % limit
> cputime         unlimited
> filesize        unlimited
> datasize        1048576 kbytes
> stacksize       32768 kbytes
> coredumpsize    unlimited
> memoryuse       2048532 kbytes
> memorylocked    2048532 kbytes
> maxproc         1044
> openfiles       3404
>
>
> Cheers,
>
> Patrick
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)