Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 42E16476633 for ; Tue, 17 Dec 2002 09:10:01 -0500 (EST) Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66]) by postgresql.org (Postfix) with ESMTP id A3887476605 for ; Tue, 17 Dec 2002 09:10:00 -0500 (EST) Received: from klaster.net (pj67.krakow.cvx.ppp.tpnet.pl [217.99.210.67]) by serwer.skawsoft.com.pl (Postfix) with ESMTP id E94F82B21C; Tue, 17 Dec 2002 14:53:48 +0100 (CET) Message-ID: <3DFF30D5.6020001@klaster.net> Date: Tue, 17 Dec 2002 15:12:37 +0100 From: Tomasz Myrta User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; en-US; rv:1.2b) Gecko/20021016 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Christoph Haller Cc: gary.stainburn@ringways.co.uk, pgsql-sql@postgresql.org Subject: Re: join and dynamic view References: <3DFF2A7B.B26EEF93@rodos.fzk.de> In-Reply-To: <3DFF2A7B.B26EEF93@rodos.fzk.de> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/203 X-Sequence-Number: 10791 Christoph Haller wrote: > Tomasz, > Could you please point out why this is not a good idea. Thanks. How often do you chage structure of this view? What happens when during querying this view someone recreates it? What happens to your reports? Do you have them already dynamic? Usually I create A4-paper based reports, so it is difficult to fit them if horizontal structure changes. Maybe creating dynamic view it is not so bad idea. I think you should watch them carefully so they don't surprise you. Tomasz Myrta