Re: How to add column from old_table to new_table?
| От | Gnanavel S |
|---|---|
| Тема | Re: How to add column from old_table to new_table? |
| Дата | |
| Msg-id | eec3b03c0509210601621958ac@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: How to add column from old_table to new_table? ("Joost Kraaijeveld" <J.Kraaijeveld@Askesis.nl>) |
| Список | pgsql-sql |
On 9/21/05, Joost Kraaijeveld <J.Kraaijeveld@askesis.nl> wrote:
It should be written has
update new_table set new_attribute=old_attribute from old_table where old_table.id=new_table.id;
Hi,
I made a mistake in describing the query I tried. The query I tried was:
update new_table
set new_attribute = (select old_attribute from old_table, new_table
where old_table.id = new_table.id)
where old_table.id = new_table.id
It should be written has
update new_table set new_attribute=old_attribute from old_table where old_table.id=new_table.id;
It actually returns the error "ERROR: more than one row returned by a
subquery used as an expression" if ran.
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
--
with regards,
S.Gnanavel
Satyam Computer Services Ltd.
В списке pgsql-sql по дате отправления: