What works:
# select o.id from op o order by o.id;
# select o.id from op o union all SELECT -1 order by id;
Does not work:
# select o.id from op o union all SELECT -1 order by o.id;
ERROR: Relation 'o' does not exist
# select o.id from op o union all SELECT -1 from op o order by o.id;
ERROR: Relation 'o' does not exist
Running today's CVS. (I finally converted my main workstation
to 7.1...)
--
marko