Postgres Pro
Downloads
Home   >   mailing lists

Re: Create a function that creates a function which returns a table and return that table in one step - Mailing list pgsql-novice

From Tom Lane
Subject Re: Create a function that creates a function which returns a table and return that table in one step
Date
Msg-id 7350.1227287920@sss.pgh.pa.us
Whole thread Raw
In response to Create a function that creates a function which returns a table and return that table in one step  (Rainer Schuetz <rs@bagong.de>)
List pgsql-novice
Tree view 
Rainer Schuetz <rs@bagong.de> writes:
> I have a function (the 'outer' function) that creates another function
> which runs a select-query on a table. This table is specified by a
> parameter I use when running the outer function (there are many
> tables, on which the query could be executed and I would like to
> prevent having to write my function for each of them).

Introducing the extra function seems to be just complicating your life.
Why don't you just EXECUTE the desired SELECT directly from the main
function?

            regards, tom lane

pgsql-novice by date:

Previous
From: Rainer Schuetz
Date:
Subject: Create a function that creates a function which returns a table and return that table in one step
Next
From: Bruce Hyatt
Date:
Subject: Roles