[SQL] update syntax

2005-06-15 Thread Praveen Raja 








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

Re: [SQL] update syntax

2005-06-15 Thread 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