Hi,
On 25/03/12 08:16, haman...@t-online.de 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
