Home > mailing lists

Count Issues - Mailing list pgsql-general

From	Dev
Subject	Count Issues
Date	October 15, 2004 00:55:17
Msg-id	6.1.0.6.2.20041014164509.024ac3c0@pop3.umpa-us.com Whole thread Raw
Responses	Re: Count Issues (Andre Maasikas <andre.maasikas@abs.ee>) Re: Count Issues (Steven Klassen <sklassen@commandprompt.com>) Re: Count Issues (John Sidney-Woollett <johnsw@wardbrook.com>) Re: Count Issues (Dev <dev@umpa-us.com>)
List	pgsql-general

Hello all,

I am trying to get a total number of rows returned form a query.

SELECT count(this) from table group by this

Currently it is returning x rows with a count of each of the group by.

I need the count of the rows returned!

Any way to do this?

		Brian C. Doyle
		Director, Internet Services
		United Merchant Processing Association
		http://www.umpa-us.com
		1-800-555-9665 ext 212

pgsql-general by date:

Previous

From: Bambero
Date: 15 October 2004, 00:39:19
Subject: Boolean

Next

From: Michael Holden
Date: 15 October 2004, 01:01:16
Subject: Possibly stupid questions re: large tables/files, port 5432 access