"Carel Combrink" <s25291930(at)tuks(dot)co(dot)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
> 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
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2010-08-31 14:26:50|
|Subject: Re: Django + Postgressql |
|Previous:||From: Carel Combrink||Date: 2010-08-31 14:16:46|
|Subject: Reduce Calculations in SELECT|