Re: views with parameters
От | Bruno Wolff III |
---|---|
Тема | Re: views with parameters |
Дата | |
Msg-id | 20041129163417.GA20174@wolff.to обсуждение исходный текст |
Ответ на | Re: views with parameters (Bruno Wolff III <bruno@wolff.to>) |
Ответы |
Re: views with parameters
|
Список | pgsql-novice |
On Sun, Nov 28, 2004 at 00:39:40 +0100, "Thomas Hermann(Software)" <hth@sprintsoft.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?
В списке pgsql-novice по дате отправления: