Re: Function Returning Table/Record

"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