Re: update syntax

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(at)interaction(dot)ws]
Sent: 15 June 2005 14:22
To: Praveen Raja
Cc: pgsql-sql(at)postgresql(dot)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(dot)raja(at)netlight(dot)se>

To: pgsql-sql(at)postgresql(dot)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