Received: from srv.ctlno.com (216-175-179-80.client.dsl.net [216.175.179.80]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1MLJQx18098 for ; Thu, 22 Feb 2001 16:19:27 -0500 (EST) (envelope-from matt@ctlno.com) Received: by srv.ctlno.com with Internet Mail Service (5.5.2650.21) id <1LHYVMJC>; Thu, 22 Feb 2001 15:13:55 -0600 Message-ID: <183FA749499ED311B6550000F87E206C1FD01D@srv.ctlno.com> From: Matthew To: "'pgsql-general@postgresql.org'" Subject: SQL Question Date: Thu, 22 Feb 2001 15:13:47 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: text/plain X-Archive-Number: 200102/1150 X-Sequence-Number: 5070 In 7.0.3 I want to do: select count( distinct browser, ssn) from applicant_sessions where browser like '%5.5%'; But I get this error: ERROR: Aggregate functions may only have one parameter In 7.1 I can do: select count(*) from (select distinct browser, ssn from applicant_sessions where browser like '%5.5%') as distinctbrow; to get the desired result, but I can't do that in 7.0.x. Any suggestions? Am I doing anything wrong with my sql syntax. I'm working around it right now by doing a pg_numrows from PHP after I do the first select, but I would like to get the count directly as it will be faster. Thanks, Matt