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

Sarah Officer wrote:

> > 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 ...
> >

you could try it with a CASE WHEN ... THEN ... ELSE ... END


oliver