Re: create type with %type or %rowtype

Hi,

> On 18. Nov, 2020, at 22:08, Post Gresql <postgresql(at)taljaren(dot)se> wrote:
>
> I might be stupid, but where in the document for create function does it say that the return type can be a table?
>
> From the doc for version 13 https://www.postgresql.org/docs/13/sql-createfunction.html
>
> "rettype
> The return data type (optionally schema-qualified). The return type can be a base, composite, or domain type, or can reference the type of a table column."

right in the syntax:

CREATE [ OR REPLACE ] FUNCTION
name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = } default_expr
] [, ...] ] )
[ RETURNS rettype
| RETURNS TABLE ( column_name column_type [, ...] ) ]

"RETURNS TABLE(...)" is probably what you're looking for?

Cheers,
Paul