| From: | Adam Haberlach <adam(at)newsnipple(dot)com> |
|---|---|
| To: | Joel Burton <jburton(at)scw(dot)org> |
| Cc: | Ed Loehr <eloehr(at)austin(dot)rr(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: UNION within VIEW workarounds? |
| Date: | 2000-12-08 02:38:00 |
| Message-ID: | 20001207183800.A13754@ricochet.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)newsnipple(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joel Burton | 2000-12-08 03:27:08 | Re: UNION within VIEW workarounds? |
| Previous Message | Brosnahan, Richard | 2000-12-08 02:15:01 | 7.0.3 on Mac OS X? |