Creating views

From: "Kashmira Patel \(kupatel\)" <kupatel(at)cisco(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Creating views
Date: 2007-03-09 02:03:45
Message-ID: 18AE59788A3FC640A367E5652E664D8003CA26C6@xmb-sjc-237.amer.cisco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Thanks,
Kashmira

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bart Degryse 2007-03-09 08:28:04 Re: A form of inheritance with PostgreSQL
Previous Message Rodrigo De León 2007-03-09 01:30:26 Re: Select when table have missing data