Re: executing a procedure withing a procedure?

Поиск
Список
Период
Сортировка
От Richard Broersma Jr
Тема Re: executing a procedure withing a procedure?
Дата
Msg-id 20060814110736.26553.qmail@web31810.mail.mud.yahoo.com
обсуждение исходный текст
Ответ на executing a procedure withing a procedure?  ("ben sewell" <mosherben@gmail.com>)
Список pgsql-novice
> What do I add on the front end in order to bid the form to a view when
> updating data?

Don't forget to copy the list when you have a question so that other can reply also.

I am not sure I understand your first question.  But if you want to bind a view to a form in
ms-access, look at:
http://www.postgresql.org/download/
under application interfaces -- odbc


> Also, the procedure I need to write are for a report in access. How would I
> link the procedure to the report? I do have several parameters for the
> procedure, so any advice is welcome.

hmm.. I never tried binding a report to a pl-pgsql function before.  I imagine that you could do
it through a pass-through query where you:
select * from <your_function>;

Alternitivly, you could create a view in postgresql that is a "select * from <your_function>" and
then bind your report to that view.

Regards,

Richard Broersma Jr.


В списке pgsql-novice по дате отправления:

Предыдущее
От: Richard Broersma Jr
Дата:
Сообщение: Re: password authentication failed for user "postgres"
Следующее
От: Mike Ellsworth
Дата:
Сообщение: Alter column