Re: Seeking Clarification on Function Definitions in PostgreSQL Extensions

On Wednesday, June 19, 2024, Ayush Vatsa <ayushvatsa1810(at)gmail(dot)com> wrote:

> Hi David,
> Thanks for clarification
> > I prefer TABLE. Using setof is more useful when the returned type is
> predefined
> But in the table also isn't the returned type predefined? Example:
> CREATE FUNCTION fun1(integer)
> RETURNS TABLE(
> col1 integer,
> col2 text
> )
> AS 'MODULE_PATHNAME', 'fun1'
> LANGUAGE C;
> We know the returned type will have two columns with type - integer and
> text. Am I correct?
>

Sorry, predefined independently of the function. Using create type then
referring to that type by name in the create function.

>
> > Or a true record where the caller has to specify the shape.
> Sorry but didn't get this shape part?
>

… from rec_func as (col1 isn’t, col2 text) …

The shape is two columns, type int and text respectively.

David J.