From: Roberto Mello <rmello@cc.usu.edu>
To: Issurdatt, Portia CECOM RDEC STCD SRC <Portia.Issurdatt@mail1.monmouth.army.mil>
Cc: pgsql-sql@postgresql.org
Subject: Re: Information passing, Perl, Unix and Postgresql Database
Date: Wed, 9 May 2001 16:37:44 -0600
Message-ID: <20010509163744.A5887@cc.usu.edu> (raw)
In-Reply-To: <DDFD9B60F648D411AD670000F80822EA014B4B78@mail7.monmouth.army.mil>
References: <DDFD9B60F648D411AD670000F80822EA014B4B78@mail7.monmouth.army.mil>
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.nethttp://www.sdl.usu.edu - Space Dynamics Lab, Developer
_ _ _ _ _ _ ////|||||||||||||| < domino effect at work
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: rmello@cc.usu.edu, Portia.Issurdatt@mail1.monmouth.army.mil
Subject: Re: Information passing, Perl, Unix and Postgresql Database
In-Reply-To: <20010509163744.A5887@cc.usu.edu>
References: <DDFD9B60F648D411AD670000F80822EA014B4B78@mail7.monmouth.army.mil> <20010509163744.A5887@cc.usu.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox