From: MichaelHoeller@t-online.de
To: pgsql-sql@postgresql.org
Subject: Re: how to update with a join?
Date: Sat, 10 Sep 2005 18:56:10 +0200
Message-ID: <200509101856.10905.MichaelHoeller@t-online.de> (raw)
In-Reply-To: <200509101847.48765.MichaelHoeller@t-online.de>
References: <200509101847.48765.MichaelHoeller@t-online.de>
Hello all,
thanks for the answere to the prev. thread. With the help of them
I solved the problme I used "not like" instead of <> and this leads
to a problem. This works for me:
update stamm
set code = replace (code, 'k' , '')
where code like '%k%' and code <> '%V%';
I would still be interested to learn how to update a row when the result
set is only reachable via a join.
Thanks a gain
Michael
Michael Hoeller wrote at Samstag, 10. September 2005 18:47:
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: MichaelHoeller@t-online.de
Subject: Re: how to update with a join?
In-Reply-To: <200509101856.10905.MichaelHoeller@t-online.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox