Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 674994758E1 for ; Thu, 21 Nov 2002 00:45:58 -0500 (EST) Received: from smtp-send.myrealbox.com (smtp-send.myrealbox.com [192.108.102.143]) by postgresql.org (Postfix) with ESMTP id 43D724758DC for ; Thu, 21 Nov 2002 00:45:57 -0500 (EST) Received: from lopht.net jgeorgeson@smtp-send.myrealbox.com [24.219.67.217] by smtp-send.myrealbox.com with NetMail SMTP Agent $Revision: 3.16 $ on Novell NetWare via secured & encrypted transport (TLS); Wed, 20 Nov 2002 22:46:03 -0700 Message-ID: <3DDC6D13.8040404@lopht.net> Date: Wed, 20 Nov 2002 23:20:19 -0600 From: Justin Georgeson User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.1) Gecko/20020826 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: select for update Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/371 X-Sequence-Number: 10513 I'm pretty new to databases in general, and would like to find a spiffy way to do something. I want to use two columns from one table to populate three columns in two other tables. Assuming t1 is the table I want to take the values from, here is the structure of what I want to insert into t2 and t3. t2.id = t1.id t2.groupname = t1.username t2.owner = t1.username t3.id = t3.groupid = t1.id t3.username = t1.username t3.writeperms = 31 PS - I'm not subscribed to the list, so please CC my email with responses. -- ; Justin Georgeson ; http://www.lopht.net ; mailto:jgeorgeson@lopht.net ; "Free the mallocs, delete the news"