On Wednesday, June 19, 2024, Ayush Vatsa <ayushvatsa1...@gmail.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.
