count syntax

From: Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: count syntax
Date: 2003-04-11 11:44:38
Message-ID: 20030411124438.B23389@quartz.newn.cam.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2003-04-11 11:48:06 Re: Batch replication ordering (was Re: [GENERAL] 32/64-bit
Previous Message tom dyson 2003-04-11 11:38:21 conditional constraints