Re: update with subselect (long)

On Thursday 17 March 2005 15:01, Stephan Szabo wrote:

> The above needs some work. The below should be acceptable to the
> system.
>
> update name_parts set name_part_type=5 from (select name_id from
> name_parts where name_part_type=6) as gpt_type where
> name_parts.name_id=gpt_type.name_id and name_part_type=3;

Thank you very much!

> I'm a bit worried about blindly changing the type for anything that
> has a name_part_type=6 record, but given your usage that might be
> okay.

Yes, this is a kind of one-shot job. I shall be going through all the
records manually later and correct the ones that don't fit the bill
exactly.
--
Leif Biberg Kristensen
http://solumslekt.org/