Re: [SQL] Help with multistage query

2005-10-04 Thread Jim C. Nasby
On Wed, Sep 07, 2005 at 05:37:47PM -0400, Matt Emmerton wrote: > > - Original Message - > From: Russell Simpkins > To: pgsql-sql@postgresql.org > Sent: Wednesday, September 07, 2005 4:05 PM > Subject: Re: [SQL] Help with multistage query > > I

Re: [SQL] Help with multistage query

2005-09-07 Thread Matt Emmerton
  - Original Message - From: Russell Simpkins To: pgsql-sql@postgresql.org Sent: Wednesday, September 07, 2005 4:05 PM Subject: Re: [SQL] Help with multistage query   I have a perl script that issues a series of SQL statements to perform some

Re: [SQL] Help with multistage query

2005-09-07 Thread Russell Simpkins
  I have a perl script that issues a series of SQL statements to perform some queries.  The script works, but I believe there must be a more elegant way to do this.   The simplified queries look like this:   SELECT id FROM t1 WHERE condition1;   ;returns about 2k record

[SQL] Help with multistage query

2005-09-07 Thread Rick Schumeyer
I have a perl script that issues a series of SQL statements to perform some queries.  The script works, but I believe there must be a more elegant way to do this.   The simplified queries look like this:   SELECT id FROM t1 WHERE condition1;   ;returns about 2k records which are stored