Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 98A492E24FB for ; Wed, 14 Nov 2007 09:47:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 26662-10 for ; Wed, 14 Nov 2007 09:47:13 -0400 (AST) Received: from bonito.ulb.ac.be (smtp.ulb.ac.be [164.15.59.220]) by postgresql.org (Postfix) with ESMTP id C77812E266B for ; Wed, 14 Nov 2007 09:47:13 -0400 (AST) Received: from [10.0.0.194] (bebif01.ulb.ac.be [164.15.125.4]) by bonito.ulb.ac.be (Postfix) with ESMTP id 9FC2F66C; Wed, 14 Nov 2007 14:47:08 +0100 (CET) Subject: Re: ALL() question From: Julien Cigar To: depesz@depesz.com Cc: pgsql-sql@postgresql.org In-Reply-To: <20071114133116.GA10440@depesz.com> References: <1195047542.3190.9.camel@frodon.be-bif.ulb.ac.be> <20071114133116.GA10440@depesz.com> Content-Type: text/plain Date: Wed, 14 Nov 2007 16:50:52 +0100 Message-Id: <1195055452.3190.23.camel@frodon.be-bif.ulb.ac.be> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200711/70 X-Sequence-Number: 29598 Thanks :) it works as expected Julien On Wed, 2007-11-14 at 14:31 +0100, hubert depesz lubaczewski wrote: > On Wed, Nov 14, 2007 at 02:39:02PM +0100, Julien Cigar wrote: > > With the following I got a syntax error: > > select specimen_id > > from specimen_test_bits > > where test_bit_id = all(1,2,3,4); > > where test_bit_id in (1,2,3,4) > group by specimen_id > having count(distinct test_bit_id) = 4; > > depesz >