Home > mailing lists

Count Issues - Mailing list pgsql-general

From	Dev
Subject	Count Issues
Date	October 14, 2004 21:55:17
Msg-id	6.1.0.6.2.20041014164509.024ac3c0@pop3.umpa-us.com Whole thread Raw
Responses	Re: Count Issues Re: Count Issues Re: Count Issues Re: Count Issues
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

From: Bambero
Date: 14 October 2004, 21:39:19
Subject: Boolean

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