UNION on views in 7.1 - Mailing list pgsql-general

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'