Re: update syntax - Mailing list pgsql-sql

From Bruno Prévost
Subject Re: update syntax
Date
Msg-id 009001c571a8$b90eb380$5d00a8c0@BRUNO2500
Whole thread Raw
In response to Re: update syntax  ("Praveen Raja" <praveen.raja@netlight.se>)
List pgsql-sql
I don't know if you can do that using the same logic.
Perhaps someone else can help?
 
For sure, you can use a subselect.
 
delete from table1
where col1 in (SELECT a.col1
              FROM table1 a JOIN table1 b ON a.col2 = b.col2
              WHERE a.col3 = ‘something’
              AND b.col3 = ‘somethingelse’)
 
----- Original Message -----
Sent: Wednesday, June 15, 2005 8:35 AM
Subject: RE: [SQL] 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@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 -----

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

pgsql-sql by date:

Previous
From: "Praveen Raja"
Date:
Subject: Re: update syntax
Next
From: Bruno Wolff III
Date:
Subject: Re: Converting varchar to bool