Re: UPDATE with value from another table
От | Oliver Elphick |
---|---|
Тема | Re: UPDATE with value from another table |
Дата | |
Msg-id | 1015050062.5762.873.camel@linda обсуждение исходный текст |
Ответ на | UPDATE with value from another table ("Thomas T. Thai" <tom@minnesota.com>) |
Ответы |
Re: UPDATE with value from another table
|
Список | pgsql-general |
On Sat, 2002-03-02 at 05:08, Thomas T. Thai wrote: > UPDATE [ ONLY ] table SET col = expression [, ...] > [ FROM fromlist ] > [ WHERE condition ] > > Is this valid: > > UPDATE table1 > SET col = table2.col > FROM table2 > WHERE col = table2.id; Yes, in principle: junk=# UPDATE table1 junk-# SET col = table2.col junk-# FROM table2 junk-# WHERE col = table2.id; ERROR: Column reference "col" is ambiguous WHERE table2.col = table1.id; -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "I will lift up mine eyes unto the hills, from whence cometh my help. My help cometh from the LORD, which made heaven and earth." Psalms 121:1,2
В списке pgsql-general по дате отправления: