Re: [SQL] update syntax

[Praveen Raja]

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:[EMAIL PROTECTED] 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 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