| From: | Ed Loehr <eloehr(at)austin(dot)rr(dot)com> |
|---|---|
| To: | Adam Haberlach <adam(at)newsnipple(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: UNION within VIEW workarounds? |
| Date: | 2000-12-08 01:45:02 |
| Message-ID: | 3A303D1E.941CCAF9@austin.rr.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Adam Haberlach wrote:
>
> On Thu, Dec 07, 2000 at 07:27:08PM -0800, Joel Burton wrote:
> > > Given UNIONs are not implemented within views in 7.0.3, what are
> > the
> > > generally suggested work-arounds, if any?
> >
> > Ick. We just did the full SELECTs all the time. A pain.
> >
> > FYI, this is fixed in 7.1. Beta Real Soon Now.
>
> Out of curiosity, what is the advantage, other then simplification
> of the query itself, of using a view over a straight select?
One advantage is that you can hide internal db schema from applications
that may need to access your db. That frees you to change the internal
schema somewhat as long as you honor the agreed "interface" of the
view...
Regards,
Ed Loehr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joel Burton | 2000-12-08 01:54:09 | Re: Modification times in records? |
| Previous Message | Franck Martin | 2000-12-08 01:23:24 | RE: Problems with Mandrake RPM |