Received: from mail1.mx.voyager.net (mail1.mx.voyager.net [216.93.66.200]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1MLcAx20491 for ; Thu, 22 Feb 2001 16:38:10 -0500 (EST) (envelope-from mitch@venux.net) Received: from windows (mdmmi052194.voyager.net [216.93.52.194] (may be forged)) by mail1.mx.voyager.net (8.10.2/8.10.2) with SMTP id f1MLc4N07259; Thu, 22 Feb 2001 16:38:04 -0500 (EST) Message-ID: <017701c09d17$9e1886b0$0200000a@windows> From: "Mitch Vincent" To: "Matthew" , References: <183FA749499ED311B6550000F87E206C1FD01D@srv.ctlno.com> Subject: Re: SQL Question Date: Thu, 22 Feb 2001 16:37:12 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200102/1152 X-Sequence-Number: 5072 > 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 To be expected for count, I think.. > 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. Are you not doing the query SELECT * FROM applicant_sessions WHERE browser LIKE '%5.5%' ? If you're not then yes, selecting just the count will be faster but if you're already doing the query then why not just see how many rows are returned by it.. It's one less step if you have to run the query anyway.. > select count(*) from (select distinct browser, ssn from applicant_sessions > where browser like '%5.5%') as distinctbrow; That would be slower than just the inner SELECT by itself, so you're not gaining anything even by doing that in 7.1.. You're still executing that sub-select and doing processing against it.. *shrug* Just some thoughts.. Good luck.. -Mitch