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