Re:How can udf c function return table, not the rows?

[Wen Yi]

You're right, thanks!








Wen Yi
wen...@qq.com






---Original---
From: "David G. Johnston"<david.g.johns...@gmail.com&gt;
Date: Fri, Jul 19, 2024 21:04 PM
To: "Wen Yi"<wen...@qq.com&gt;;
Cc: "pgsql-hackers"<pgsql-hackers@lists.postgresql.org&gt;;
Subject: How can udf c function return table, not the rows?


On Thursday, July 18, 2024, Wen Yi <wen...@qq.com&gt; wrote:

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
pg_get_functiondef&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 &nbsp;
----------------------------------------------------------------------



In my expectations, it should be:


&nbsp;oid&nbsp; 
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
pg_get_functiondef&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 &nbsp;
------+------------------------------------------------------------------------


Can someone give my some advice?




Write:


Select * from function_call()


Instead of


Select function_call()&nbsp;


Guessing a bit since you never did show the first query.


David J.