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

You're right, thanks!

Wen Yi
wen-yi(at)qq(dot)com

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

On Thursday, July 18, 2024, Wen Yi <wen-yi(at)qq(dot)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.