Re: join and dynamic view - Mailing list pgsql-sql

From Christoph Haller
Subject Re: join and dynamic view
Date
Msg-id 3DFF3177.3EBB9DFC@rodos.fzk.de
Whole thread Raw
In response to join and dynamic view  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
List pgsql-sql
>
> 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




pgsql-sql by date:

Previous
From: Tomasz Myrta
Date:
Subject: Re: join and dynamic view
Next
From: Gary Stainburn
Date:
Subject: Re: join and dynamic view