Sarah Officer wrote:
>
> I am converting some Oracle stuff to Postgres (or attempting to
> convert it :) ), and I'm having trouble with my views. I have
> figured out the syntax difference between Oracle & Postgres, I
> think, but Postgres doesn't seem to know the type of a constant text
> column. How can I make this work?
>
> The view is something like this:
>
> create view Foo as
> select a, b, c, 'OK' as status
> from table1
> where ...
> union
> select a, b, c, 'BAD' as status
> from table1
> where ...
>
select a, b, c, 'OK'::varchar(3) as status ...
Concerning the union:
1. create separate views with the same structure
2. use a select of the form:
select a, b, c, status from view1 where ... union select a, b, c, status
from view2 where ...
Regards
Wim