From: | shawn everett <everett(at)pgweb(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Is this possible or am I on drugs :) |
Date: | 2000-11-28 00:28:51 |
Message-ID: | Pine.LNX.4.30.0011271604540.23337-100000@alder.pgweb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have a web application that needs to generate a report. Said report
requires a lot of calcuations so that hard coding them is a pain.
I would like to set up a view does does all the apropriate selects and
calculations to make writing my report easier. Is it possible to pass a
user supplied parameter to a view? Would a procedure make this easier?
I could write the query in the code to accomplish want I want but I'm
always looking for new and interesting ways to accomplish things. :)
From a general point of view I want to do something like:
select stuff from table where something=UserSuppliedParameter.
Is this possible to do from within Postgres? How would I go about getting
the User Supplied Parameter? How would I pass it using PHP?
Any comments would be apreciated
Shawn
From | Date | Subject | |
---|---|---|---|
Next Message | clayton cottingham | 2000-11-28 00:30:24 | Re: [PHP-DB] Re: [SQL] a script that queries database periodically |
Previous Message | Roberto Mello | 2000-11-28 00:10:55 | Re: [PHP-DB] Re: [SQL] a script that queries database periodically |