From: Michael Hoeller <MichaelHoeller@t-online.de>
Reply-To: Michael Hoeller <MichaelHoeller@t-online.de>
To: pgsql-sql@postgresql.org
Subject: how to update with a join?
Date: Sat, 10 Sep 2005 18:47:48 +0200
User-Agent: KMail/1.7.1
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200509101847.48765.MichaelHoeller@t-online.de>

Hello 

I like to delete "k" from a string with the statement 
update stamm set code = replace (code, 'k' , '');

But the only way to get the canditates I want to update is the following 
statement. It seems that I can not update when I do a join. 

Is there a way around it? With google I found a hint that a subselect
could help but there was no exsample ... And I did not found out how 
to do this.

select a.code 
from stamm a 
where 
a.skart in ( 
	(select skart 
	from stamm 
	where code like '%k%') 
	) 
and a.code not like '%V%';

I would be happy about a hint.

Thanks a lot 
Michael