Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9044C476A08 for ; Thu, 24 Oct 2002 05:33:08 -0400 (EDT) Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66]) by postgresql.org (Postfix) with ESMTP id E8B00476A18 for ; Thu, 24 Oct 2002 05:33:07 -0400 (EDT) Received: from klaster.net (pd53.krakow.cvx.ppp.tpnet.pl [213.76.39.53]) by serwer.skawsoft.com.pl (Postfix) with ESMTP id 9A9502B4D6; Thu, 24 Oct 2002 11:26:26 +0200 (CEST) Message-ID: <3DB7BFC5.5050705@klaster.net> Date: Thu, 24 Oct 2002 11:39:17 +0200 From: Tomasz Myrta User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; PL; rv:1.1) Gecko/20020826 X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: Tomasz Myrta Cc: Stephan Szabo , pgsql-sql@postgresql.org Subject: Re: sub-select with aggregate References: <20021023071418.N4419-100000@megazone23.bigpanda.com> <3DB7BF5A.1090606@klaster.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/329 X-Sequence-Number: 10046 Sorry, In second query is: drop view v; create view v as select B.id_biletu... Tomasz Myrta