Re: Using a Storedprocedure as a View

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Alexander Hachmann" <public(at)thesofa(dot)de>, "Pgsql" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Using a Storedprocedure as a View
Date: 2004-03-09 17:51:08
Message-ID: 200403091851.08208.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Hachmann 2004-03-09 17:57:32 Re: Using a Storedprocedure as a View
Previous Message Peter Eisentraut 2004-03-09 17:47:43 Re: dontExecute Flag