Postgres Pro
Downloads
Home   >   mailing lists

count syntax - Mailing list pgsql-general

From Patrick Welche
Subject count syntax
Date
Msg-id 20030411124438.B23389@quartz.newn.cam.ac.uk
Whole thread Raw
Responses Re: count syntax  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: count syntax  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
Tree view 
What is the difference between the following?

transatlantic=# select count(*) from trans;
 count
--------
 453602
(1 row)

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

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

% 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

pgsql-general by date:

Previous
From: tom dyson
Date:
Subject: conditional constraints
Next
From: Jan Wieck
Date:
Subject: Re: Batch replication ordering (was Re: [GENERAL] 32/64-bit