Re: Function Returning Table/Record - Mailing list pgsql-novice

From Tom Lane
Subject Re: Function Returning Table/Record
Date
Msg-id 2232.1283264518@sss.pgh.pa.us
Whole thread Raw
In response to Function Returning Table/Record  ("Carel Combrink" <s25291930@tuks.co.za>)
Responses Re: Function Returning Table/Record  ("Carel Combrink" <s25291930@tuks.co.za>)
List pgsql-novice
"Carel Combrink" <s25291930@tuks.co.za> writes:
> I have a function that returns a subset of data from a specific table.
> The function must return all the rows that are present in the parent
> table.

> Is there an easy way to create this function so that when the table
> definition changes I don't need to change the function definition.
> I know I can create the table to return RECORD but then when I call
> the function I must specify the structure of the returned type.

Can't you declare it as returning the table's rowtype?

            regards, tom lane

pgsql-novice by date:

Previous
From: "Carel Combrink"
Date:
Subject: Reduce Calculations in SELECT
Next
From: "SUNDAY A. OLUTAYO"
Date:
Subject: Re: Django + Postgressql