Fwd: [SQL] refining view using temp tables

2006-11-06 Thread Aaron Bono
-- Forwarded message --From: Aaron Bono <[EMAIL PROTECTED]>Date: Nov 6, 2006 4:51 PM Subject: Re: [SQL] refining view using temp tablesTo: BeemerBiker <[EMAIL PROTECTED]>Cc: pgsql-sql@postgresql.org On 10/31/06, BeemerBiker <[EMAIL PROTECTED]> wrote: Using postgre with dotnet VS8. 

[SQL] refining view using temp tables

2006-11-06 Thread BeemerBiker
Using postgre with dotnet VS8. I came up with a scheme of having a web user search thru the database and selecting into a temp table. Then a further "refined" search would use the temp table as input and another temp table as output. Then swap the source and destination so as to not use up reso