Received: from tisch.mail.mindspring.net (tisch.mail.mindspring.net [207.69.200.157]) by hub.org (8.10.1/8.11.0) with ESMTP id e9JI7In63079 for ; Thu, 19 Oct 2000 14:07:18 -0400 (EDT) (envelope-from bcdoyle@mindspring.com) Received: from hbg-dnt-1467.mindspring.com (fw-6-e3.atl2.mindspring.net [207.69.162.124]) by tisch.mail.mindspring.net (8.9.3/8.8.5) with ESMTP id OAA32159; Thu, 19 Oct 2000 14:07:07 -0400 (EDT) Message-Id: <5.0.0.25.2.20001019140625.049308b0@pop.mindspring.com> X-Sender: bcdoyle@pop.mindspring.com X-Mailer: QUALCOMM Windows Eudora Version 5.0 Date: Thu, 19 Oct 2000 14:07:15 -0400 To: craig.may@s2.enthdimension.com.au, pgsql-sql@postgresql.org From: "Brian C. Doyle" Subject: Re: COUNT In-Reply-To: <20001020045843.A6717@s2.enthdimension.com.au> References: <20000906202707.A4767@s2.enthdimension.com.au> <20000906202707.A4767@s2.enthdimension.com.au> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200010/180 X-Sequence-Number: 1842 Hello, You will need to do "SELECT count(attribute) FROM table;" or SELECT count(table.attribute);" At 04:58 AM 10/20/00 +0000, Craig May wrote: >Hi, > >How do I get a row count, like "Select [COUNT] from Table" ?? > >Regards, >Craig May > >Enth Dimension >http://www.enthdimension.com.au