Re: Using a Storedprocedure as a View - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Using a Storedprocedure as a View
Date
Msg-id 200403091851.08208.peter_e@gmx.net
Whole thread Raw
In response to Using a Storedprocedure as a View  ("Alexander Hachmann" <public@thesofa.de>)
List pgsql-general
Alexander Hachmann wrote:
> I need to create a Procedure that returns the same data as a view
> does except, that the the
> data was filtered by a parameter.
> I want to execute a procedure with a parameter and get back a 'view'.

It is possible to create a function that returns multiple rows, but the
interface is different depending on the language used to implement the
function.  Read up on "table functions" in the documentation.


pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: Using a Storedprocedure as a View
Next
From: Bill Moran
Date:
Subject: Re: Using a Storedprocedure as a View