Re: UNION within VIEW workarounds? - Mailing list pgsql-general

From Adam Haberlach
Subject Re: UNION within VIEW workarounds?
Date
Msg-id 20001207183800.A13754@ricochet.net
Whole thread Raw
In response to Re: UNION within VIEW workarounds?  ("Joel Burton" <jburton@scw.org>)
List pgsql-general
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?

--
Adam Haberlach           |A cat spends her life conflicted between a
adam@newsnipple.com      |deep, passionate, and profound for fish and
http://www.newsnipple.com|an equally deep, passionate, and profound
'88 EX500                |desire to avoid getting wet.

pgsql-general by date:

Previous
From: "Joel Burton"
Date:
Subject: Re: UNION within VIEW workarounds?
Next
From: ashley
Date:
Subject: Mac