"Traci Sumpter" <Traci.Sumpter@opus.co.nz> writes:
> Cheesy one here....
Got a cheesy answer for you --- cast the result ...
regression=# create view voo as
regression-# select f1::varchar(20) from
regression-# (select f1 from foo union select f2 from foo) ss;
CREATE VIEW
regression=# \d voo View "public.voo"Column | Type | Modifiers
--------+-----------------------+-----------f1 | character varying(20) |
View definition:SELECT ss.f1::character varying(20) AS f1 FROM ( SELECT foo.f1 FROM foo
UNION SELECT foo.f2 FROM foo) ss;
regards, tom lane