* Dev <[EMAIL PROTECTED]> [2004-10-14 16:54:56 -0400]: > I am trying to get a total number of rows returned form a query. > > SELECT count(this) from table group by this
Remove the 'group by' clause -- you don't need it. -- Steven Klassen - Lead Programmer Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Replication & Support Services, (503) 667-4564 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend