Re: count syntax

On Fri, Apr 11, 2003 at 12:44:38 +0100,
Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)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(at)postgresql(dot)org)