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  ("Thomas Hermann(Software)" <hth@sprintsoft.de>)
Список 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 по дате отправления:

Предыдущее
От: "Keith Worthington"
Дата:
Сообщение: Parallel versions on Red Hat Linux ES v3
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Parallel versions on Red Hat Linux ES v3