Hi folks,
I was wondering if postgres executes a subquery in an UPDATE clause once
and use the result (of the subquery) for all the updates.
Example:
UPDATE table SET field1 = (SELECT field2 FROM table2 WHERE field3 = '123')
Sorry if it seems to be a stupid question, but sometimes this kind of
update is so slow in my server, that makes me suspicious.
TIA
--
Diogo de Oliveira Biazus
diogo(at)ikono(dot)com(dot)br
Ikono Sistemas e Automação
http://www.ikono.com.br