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

Fri, 19 Jul 2024 16:27:18 -0700 

You're right, thanks!








Wen Yi
[email protected]






---Original---
From: "David G. Johnston"<[email protected]&gt;
Date: Fri, Jul 19, 2024 21:04 PM
To: "Wen Yi"<[email protected]&gt;;
Cc: "pgsql-hackers"<[email protected]&gt;;
Subject: How can udf c function return table, not the rows?


On Thursday, July 18, 2024, Wen Yi <[email protected]&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.

Reply via email to