Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 61CD2475F25
	for <pgsql-sql@postgresql.org>; Tue, 17 Dec 2002 09:15:19 -0500 (EST)
Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52])
	by postgresql.org (Postfix) with SMTP id D307A475DC0
	for <pgsql-sql@postgresql.org>; Tue, 17 Dec 2002 09:15:17 -0500 (EST)
Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ;
 Tue Dec 17 15:15:20 2002 +0100
Received: œby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id PAA19295 for <pgsql-sql@postgresql.org>; Tue, 17 Dec 2002 15:15:19 +0100 (MET)
Message-ID: <3DFF3177.3EBB9DFC@rodos.fzk.de>
Date: Tue, 17 Dec 2002 15:15:19 +0100
From: Christoph Haller <ch@rodos.fzk.de>
X-Mailer: Mozilla 4.06 [en] (X11; I; HP-UX B.10.20 9000/780)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: join and dynamic view
Content-Type: text/plain; charset=iso-8859-2
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200212/204
X-Sequence-Number: 10792

>
> Christoph Haller wrote:
>
> > Tomasz,
> > Could you please point out why this is not a good idea. Thanks.
>
> How often do you change 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 is not so bad idea. I think you should
> watch them carefully so they don't surprise you.
>
> Tomasz Myrta
>
Good Points. Thanks again.

Regards, Christoph