Hello,
I am working on a meta-programming use-case where I need to scrape some
detailed information about the results of a function that "RETURNS TABLE (LIKE
physical_table)", which ends up with prorettype = 'physical_table'::regtype.
The problem is that for the query "SELECT * FROM my_function(
On Friday, June 21, 2024 10:48 AM David G. Johnston
wrote:
>Yes, but the bug is yours. The definition you want is: RETURNS SETOF
>physical_table (not tested though)
>What you did was produce a one-column table whose column type is a composite
>(and whose name is like - what with case-folding
On Friday, June 21, 2024 11:28 AM David G. Johnston
wrote:
> Interesting, then I suppose it is semantics. There is no table involved -
> you are referencing the type of that name, not the table - so no TableOID.
> There is no guarantee the row you are holding came from a table - and I'd
> i