Received: from fslc.ser.usu.edu (fslc.ser.usu.edu [129.123.28.122]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f49MbxA54397 for ; Wed, 9 May 2001 18:37:59 -0400 (EDT) (envelope-from rmello@fslc.usu.edu) Received: (from rmello@localhost) by fslc.ser.usu.edu (8.12.0.Beta5/8.12.0.Beta5/Debian 8.12.0-1) id f49MbiUw005917; Wed, 9 May 2001 16:37:44 -0600 Date: Wed, 9 May 2001 16:37:44 -0600 From: Roberto Mello To: "Issurdatt, Portia CECOM RDEC STCD SRC" Cc: pgsql-sql@postgresql.org Subject: Re: Information passing, Perl, Unix and Postgresql Database Message-ID: <20010509163744.A5887@cc.usu.edu> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.17i In-Reply-To: ; from Portia.Issurdatt@mail1.monmouth.army.mil on Wed, May 09, 2001 at 02:38:14PM -0400 X-Archive-Number: 200105/68 X-Sequence-Number: 2869 On Wed, May 09, 2001 at 02:38:14PM -0400, Issurdatt, Portia CECOM RDEC STCD SRC wrote: > I need to extract information from a database table, do another query on > that information, then pass only the new information to a new table using > postgresql database and Unix. You might be able to do it with subqueries. PostgreSQL 7.1 has subqueries in the FROM clause as well al regular sebqueries. Read the subqueries chapter of Bruce Momjian's PostgreSQL book for more info, or give us more information. The book is at http://www.ca.postgresql.org/docs/awbook.html -Roberto -- +----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer _ _ _ _ _ _ ////|||||||||||||| < domino effect at work