Content-Type: text/plain;
  charset="us-ascii"
From: Gary Stainburn <gary.stainburn@ringways.co.uk>
Organization: Ringways Garages Ltd
To: pgsql-sql@postgresql.org
Subject: simple update from select ??
Date: Mon, 7 Mar 2005 12:28:39 +0000
User-Agent: KMail/1.4.3
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Message-Id: <200503071228.39699.gary.stainburn@ringways.co.uk>

Hi folks

I've got a table of pieces of equipment.
One piece of equipment may be owned by another piece of equipment, and 
may own multiple other pieces.

To hold the relationship I have a piece_pieces table holding the owner 
(pp_id) part id and the owned part ids (pp_part).

I'v realised I can store this within the original table so I've added an 
owner attribute.  I need to now populate this now from the other table, 
but I can't work out how.

I've got  pieces table

p_id		-- part id
p_owner	-- new owner attribute

piece_pieces table

pp_id	-- id of owner
pp_part	-- id of owned


-- 
Gary Stainburn
 
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000