Re: [GENERAL] constant column value in view with union

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