Postgres Pro
Downloads
Home   >   mailing lists

Re: How to add column from old_table to new_table? - Mailing list pgsql-sql

From Joost Kraaijeveld
Subject Re: How to add column from old_table to new_table?
Date
Msg-id 1127307055.20038.25.camel@Panoramix
Whole thread Raw
In response to How to add column from old_table to new_table?  (Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>)
Responses Re: How to add column from old_table to new_table?
List pgsql-sql
Tree view 
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 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

pgsql-sql by date:

Previous
From: Joost Kraaijeveld
Date:
Subject: How to add column from old_table to new_table?
Next
From: "A. Kretschmer"
Date:
Subject: Re: How to add column from old_table to new_table?