Обсуждение: UNION within VIEW workarounds?
Given UNIONs are not implemented within views in 7.0.3, what are the generally suggested work-arounds, if any? Regards, Ed Loehr
> 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. -- Joel Burton, Director of Information Systems -*- jburton@scw.org Support Center of Washington (www.scw.org)
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.
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
On Thu, Dec 07, 2000 at 07:45:02PM -0600, Ed Loehr wrote: > 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... another advantage is that at some point of time when you need greater performance on select's you can change your views to physical tables regenerated from time to time. depesz -- hubert depesz lubaczewski ------------------------------------------------------------------------ najwspanialszą rzeczą jaką dało nam nowoczesne społeczeństwo, jest niesamowita wręcz łatwość unikania kontaktów z nim ...