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

From Alexander Hachmann
Subject Using a Storedprocedure as a View
Date
Msg-id NGEEJJBKDBJKFGILNCLPGEKJCDAA.public@thesofa.de
Whole thread Raw
Responses Re: Using a Storedprocedure as a View
Re: Using a Storedprocedure as a View
Re: Using a Storedprocedure as a View
Re: Using a Storedprocedure as a View
List pgsql-general
Hello,
I know that this was discussed many times, but all the answers did not help
me yet.
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'.
I only made prcedures giving back simple values. Can they give back data as
Views does.
I dont want the procedure to create a view on which i have to query again
because the query the Procedure does
can go over more stages than just this one. The procedure calls another
procedure and handles this as a subselect.
Can any one help me?
Thx,
   Alexander


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Expression indexes and casts
Next
From: "Steve Wolfe"
Date:
Subject: Re: Question on Opteron performance