Arjen van der Meijden <[EMAIL PROTECTED]> writes: > Well, I have discarded this type of query as "too inefficient" and found a > better way
Loading the mapping into a table with an index and doing an update using "from" to do a join seems likely to end up being the most efficient method. Postgres would probably not even bother with the index and do a hash join. -- greg ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster