Re: executing a procedure withing a procedure? - Mailing list pgsql-novice

From Richard Broersma Jr
Subject Re: executing a procedure withing a procedure?
Date
Msg-id 20060814110736.26553.qmail@web31810.mail.mud.yahoo.com
Whole thread Raw
In response to executing a procedure withing a procedure?  ("ben sewell" <mosherben@gmail.com>)
List 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 by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: password authentication failed for user "postgres"
Next
From: Mike Ellsworth
Date:
Subject: Alter column