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