From: treeml <treeml@itree.org>
To: pgsql-sql@postgresql.org
Subject: update more than 1 table (mysql to postgres)
Date: Fri, 30 Jan 2004 03:19:32 -0500
Message-ID: <AOEMLAIJIPAIPHJEAHBOCEHJDPAA.treeml@itree.org> (raw)
I am migrating from MySQL to Postagres. I have problem with postgres
updating 2 tables with one statement.
In MySQL I can update 2 tables (parent, child) with a statement like this
UPDATE parent LEFT JOIN child ON parent.pid = child.foreign_key SET
parent.field1 = 'company',
child.field2 = 'john'
WHERE child.pid = 7
Or I can also do
UPDATE parent, child SET parent.field1 = 'company', child.field2 = 'john'
WHERE
parent.pid = child.foreign_key
AND child.pid = 7
But I couldn't do that in Postgres,
Only one table is allowed in an update statement. I tried to create a view,
and updating the view, but that was not allowed. I could do 2 SQL
updates, but I am sure there is a better way to do this. Anyone have any
idea. Appreciated.
Tree
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: treeml@itree.org
Subject: Re: update more than 1 table (mysql to postgres)
In-Reply-To: <AOEMLAIJIPAIPHJEAHBOCEHJDPAA.treeml@itree.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox