X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 6F6E79DCAD6 for ; Wed, 22 Mar 2006 14:52:30 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 16317-07 for ; Wed, 22 Mar 2006 14:52:30 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from isb.com.pl (isb.com.pl [212.160.150.140]) by postgresql.org (Postfix) with ESMTP id 69CE99DCA84 for ; Wed, 22 Mar 2006 14:52:28 -0400 (AST) Received: from maciek (sembrz [192.168.1.50]) by isb.com.pl (Postfix) with ESMTP id 1FAEA57842 for ; Wed, 22 Mar 2006 19:49:05 +0100 (CET) Date: Wed, 22 Mar 2006 19:52:27 +0100 From: Maciej Piekielniak X-Mailer: The Bat! (v1.62r) Reply-To: Maciej Piekielniak X-Priority: 3 (Normal) Message-ID: <844627747.20060322195227@isb.com.pl> To: pgsql-sql@postgresql.org Subject: Re: How to optimize this query? In-Reply-To: <684362e10603221032t4b07f5edu@mail.gmail.com> References: <827987076.20060322181715@isb.com.pl> <684362e10603220958s2dac37cfp@mail.gmail.com> <1731392587.20060322191801@isb.com.pl> <684362e10603221027t354b079bh@mail.gmail.com> <684362e10603221032t4b07f5edu@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.1 required=5 tests=[AWL=0.100] X-Spam-Score: 0.1 X-Spam-Level: X-Archive-Number: 200603/359 X-Sequence-Number: 24705 Hello Markus, ERROR: column "foo.z_zamowien" must appear in the GROUP BY clause or be used in an aggregate function -- Best regards, Maciej mailto:piechcio@isb.com.pl