UNION on views in 7.1

Started by Dan Wilsonabout 25 years ago2 messagesgeneral
Jump to latest
#1Dan Wilson
phpPgAdmin@acucore.com

Are UNIONs on views impemented in 7.1? I see several enahncements to the
view functionality in the TODO, but not this specifically. If not in 7.1,
is it planned for a future release?

-Dan

PostgreSQL said: ERROR: UNION on views is not implemented

Your query:
create view user_friend_vw
as
select
username, password, friend_id, last_name, given_names
from
friend f, auth a where a.pri_key = f.friend_id
and a.auth_table = 'friends' and a.live = 't'
UNION
select
username, password, uid, last_name, first_name
from
user_info u, auth a where a.live = 't'
and a.pri_key = u.uid and a.auth_table = 'user_info'

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Dan Wilson (#1)
Re: UNION on views in 7.1

"Dan Wilson" <phpPgAdmin@acucore.com> writes:

Are UNIONs on views impemented in 7.1?

Yes. (The error message is misworded, since it should've said UNION
*in* views, but never mind that now...)

regards, tom lane