From: Praveen Raja <praveen.raja@netlight.se>
To: 'Bruno Prévost' <bp@interaction.ws>
Cc: pgsql-sql@postgresql.org
Subject: Re: update syntax
Date: Wed, 15 Jun 2005 14:35:42 +0200
Message-ID: <003001c571a6$c337a1c0$4c0ca8c0@sek.se> (raw)
In-Reply-To: <006b01c571a4$dbbb7d40$5d00a8c0@BRUNO2500>
Thanks. The UPDATE works ok now. But using the same logic it doesn’t
seem possible to delete rows. Is this also possible?
/P
-----Original Message-----
From: Bruno Prévost [mailto:bp@interaction.ws]
Sent: 15 June 2005 14:22
To: Praveen Raja
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] update syntax
Try something like this
UPDATE table1
SET col1 = b.col1
FROM table1 b
WHERE table1.col2 = b.col2 and
table1.col3 = ‘something’ and
b.col3 = ‘somethingelse’
----- Original Message -----
From: Praveen Raja <mailto:praveen.raja@netlight.se>
To: pgsql-sql@postgresql.org
Sent: Wednesday, June 15, 2005 7:39 AM
Subject: [SQL] update syntax
Hi,
While using Ms SQL server I used to write update statements like this,
UPDATE a SET a.col1 = b.col1
FROM table1 a
INNER JOIN table1 b
ON a.col2 = b.col2
WHERE a.col3 = ‘something’
AND b.col3 = ‘somethingelse’
But I can’t seem to do this in postgres, it gives me an error saying
‘syntax error at or near “.”’. How can I do something similar to this
i.e. join on the same table?
Thanks,
/P
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: praveen.raja@netlight.se, bp@interaction.ws
Subject: Re: update syntax
In-Reply-To: <003001c571a6$c337a1c0$4c0ca8c0@sek.se>
* 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