Re: UPDATE COMPATIBILITY
От
Adrian Klaver
Тема
Re: UPDATE COMPATIBILITY
Дата
Msg-id
201201170719.47830.adrian.klaver@gmail.com
Ответ на
Re: UPDATE COMPATIBILITY (Thomas Kellerer)
Список
Дерево обсуждения
UPDATE COMPATIBILITY Gera Mel Handumon <geramel.h@gmail.com>
Re: UPDATE COMPATIBILITY Thomas Kellerer <spam_eater@gmx.net>
Re: UPDATE COMPATIBILITY Adrian Klaver <adrian.klaver@gmail.com>
Re: UPDATE COMPATIBILITY Thomas Kellerer <spam_eater@gmx.net>
Re: UPDATE COMPATIBILITY Samuel Gendler <sgendler@ideasculptor.com>
On Tuesday, January 17, 2012 12:49:44 am Thomas Kellerer wrote: > Gera Mel Handumon, 17.01.2012 07:31: > > None as far as I know. > > You need to rewrite it to: > > UPDATE accounts > SET contact_last_name = s.last_name, > contact_first_name = s.first_name > FROM salesmen s > WHERE s.id = accounts.sales_id For completeness, you could also do: UPDATE accounts SET (contact_last_name,contact_first_name)= (s.last_name,s.first_name)FROM salesmen sWHERE s.id = accounts.sales_id Gets you a little closer to what you want:) -- Adrian Klaver adrian.klaver@gmail.com
В списке pgsql-sql по дате отправления
