Received: from mail.netgates.co.uk (mail.netgates.co.uk [194.105.64.74]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eARJJot67758 for ; Mon, 27 Nov 2000 14:19:50 -0500 (EST) (envelope-from lists@a1.org.uk) Received: from a1.org.uk (martha.netgates.co.uk [194.105.64.211]) by mail.netgates.co.uk (Mirapoint) with ESMTP id BAO00806 (AUTH anthony); Mon, 27 Nov 2000 19:20:01 GMT Message-ID: <3A22B3E1.68A66ABD@a1.org.uk> Date: Mon, 27 Nov 2000 19:20:01 +0000 From: Anthony X-Mailer: Mozilla 4.72 [en] (X11; I; Linux 2.2.12 i386) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: count( distinct x ) References: <3A229EBB.F55BA11@a1.org.uk> <11661.975352224@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200011/248 X-Sequence-Number: 279 Tom Lane wrote: > Anthony writes: > > select count( distinct area ) from areapostcode where postcode like > > 'BS1%' > > the above statement fails with > > ERROR: parser: parse error at or near "distinct" > > What Postgres version are you running? Support for count(distinct foo) > was added in 7.0, IIRC. > > regards, tom lane select version(); version ------------------------------------------------------------------- PostgreSQL 6.5.3 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66 (1 row) bugger! any ideas how to get same result at relative speed with different query? Thanks Tom.