Re: join and dynamic view

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
Cc: gary(dot)stainburn(at)ringways(dot)co(dot)uk, pgsql-sql(at)postgresql(dot)org
Subject: Re: join and dynamic view
Date: 2002-12-17 14:12:37
Message-ID: 3DFF30D5.6020001@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Christoph Haller 2002-12-17 14:15:19 Re: join and dynamic view
Previous Message Gary Stainburn 2002-12-17 14:11:53 Re: join and dynamic view