Thread: UNION on views in 7.1

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'

"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