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'