Re: Defining Field Types with view

"Traci Sumpter" <Traci(dot)Sumpter(at)opus(dot)co(dot)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