X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id ACD5256624 for ; Thu, 17 Mar 2005 13:36:51 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 33995-03 for ; Thu, 17 Mar 2005 13:36:49 +0000 (GMT) Received: from mail43-s.fg.online.no (mail43-s.fg.online.no [148.122.161.43]) by svr1.postgresql.org (Postfix) with ESMTP id 0BD7E565DD for ; Thu, 17 Mar 2005 13:36:48 +0000 (GMT) Received: from [192.168.0.57] (062016240144.customer.alfanett.no [62.16.240.144]) by mail43.fg.online.no (8.12.11/8.12.11) with ESMTP id j2HDap10014248 for ; Thu, 17 Mar 2005 14:36:52 +0100 (CET) From: "Leif B. Kristensen" To: pgsql-sql@postgresql.org Subject: Re: update with subselect (long) Date: Thu, 17 Mar 2005 14:36:51 +0100 User-Agent: KMail/1.7.2 References: <200503171407.11017.leif@solumslekt.org> In-Reply-To: <200503171407.11017.leif@solumslekt.org> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200503171436.51781.leif@solumslekt.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.333 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/241 X-Sequence-Number: 20720 On Thursday 17 March 2005 14:07, Leif B. Kristensen wrote: > slekta=> update name_parts set name_part_type=6 where > name_part_type=3; This message was sent a little prematurely while I was editing a similar posting to comp.databases. The cited line is erroneous and should read: > slekta=> update name_parts set name_part_type=6 where > name_part_type=4; If somebody recognizes my data structure and can recommend some reading on working with this kind of data, I'd be much obliged. regards, -- Leif Biberg Kristensen http://solumslekt.org/