| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | "Thomas Hermann(Software)" <hth(at)sprintsoft(dot)de> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: views with parameters |
| Date: | 2004-11-29 16:34:17 |
| Message-ID: | 20041129163417.GA20174@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Sun, Nov 28, 2004 at 00:39:40 +0100,
"Thomas Hermann(Software)" <hth(at)sprintsoft(dot)de> wrote:
Usually you want to keep responses coppied to the list so that others
can comment on the thread.
> Thank you very much for your expedient response. I am currently running the
> 8 beta.
> 1) I want to modify the returned result set by sending different values used
> in the where clause, hence I get the desired information from the table.
> Assume I have the profile ID of a user an need to know the details of the
> profile, I can feed the profile to the view ID and get the proper details
> back. If the select statement within a view does not change, I can as well
> have select statement stored elsewhere.
You can supply the profile ID in a where clause when you select from the
view. Is there some reason you can't do that?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Flowers | 2004-11-29 18:45:54 | Re: problematic upgrade |
| Previous Message | Tom Lane | 2004-11-29 16:23:21 | Re: Parallel versions on Red Hat Linux ES v3 |