can these queries be combined into one? - Mailing list pgsql-general

Hi,

I am currently doing something like

select ordercode, descr, codes into temp table x from products where ...
Here codes is a bit-mapped field
update x set codes = codes | 512 from othertable t where ordercode = t.ordercode and ....
select * from x

Is there a way to avoid that temp table?

Regards
Wolfgang Hamann