| From: | Roberto Mello <rmello(at)cc(dot)usu(dot)edu> |
|---|---|
| To: | "Issurdatt, Portia CECOM RDEC STCD SRC" <Portia(dot)Issurdatt(at)mail1(dot)monmouth(dot)army(dot)mil> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Information passing, Perl, Unix and Postgresql Database |
| Date: | 2001-05-09 22:37:44 |
| Message-ID: | 20010509163744.A5887@cc.usu.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joseph Shraibman | 2001-05-09 23:39:46 | Re: 'record old is unassigned yet' when using trigger in 7.1.1 |
| Previous Message | Joseph Shraibman | 2001-05-09 22:25:23 | Re: 'record old is unassigned yet' when using trigger in 7.1.1 |