Message-ID: <45F11BF8.4080809@archonet.com>
Date: Fri, 09 Mar 2007 08:34:00 +0000
From: Richard Huxton <dev@archonet.com>
User-Agent: IceDove 1.5.0.9 (X11/20061220)
MIME-Version: 1.0
To: "Kashmira Patel (kupatel)" <kupatel@cisco.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Creating views
References: 
 <18AE59788A3FC640A367E5652E664D8003CA26C6@xmb-sjc-237.amer.cisco.com>
In-Reply-To: 
 <18AE59788A3FC640A367E5652E664D8003CA26C6@xmb-sjc-237.amer.cisco.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Kashmira Patel (kupatel) wrote:
> Hi all, Is it possible to create views that take parameters?
> Basically, I have to create some very complex historical reports, and
> as of now I am using temporary tables to store intermediate query
> results. I calculate values based on the content of these temporary
> tables and use them in the final result. I would like to eliminate
> the need for temporary tables and use views instead, as the data copy
> between the temp tables is taking quite some time.

You can write a function (in SQL even) that would basically be a 
parameterised view.

However, views don't "store" anything, so whether you see an improvement 
in speed will depend on how long it takes to do your calculations.

-- 
   Richard Huxton
   Archonet Ltd