Hi, On 25/03/12 08:16, hamann.w@xxxxxxxxxxx wrote:
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?
You just want to map some of the values in the codes field to different values? If so, case/when should help, something like:
select ordercode, descr, case when ordercode = t.ordercode and .... then codes | 512 else codes end as "codes" from products where ...
Note this is a read-only operation - some of the other answers seemed to be updating the base tables, although maybe that's what you wanted?
cheers, Tom -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
