Arjen van der Meijden <acmmailing@vulcanus.its.tudelft.nl> 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