Re:How can udf c function return table, not the rows? - Mailing list pgsql-hackers

From Wen Yi
Subject Re:How can udf c function return table, not the rows?
Date
Msg-id tencent_9793550AD314C8D2383F373BE94B97E2BA07@qq.com
Whole thread Raw
In response to How can udf c function return table, not the rows?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-hackers
You're right, thanks!



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

On Thursday, July 18, 2024, Wen Yi <wen-yi@qq.com> wrote:

                          pg_get_functiondef                          
----------------------------------------------------------------------

In my expectations, it should be:

 oid  |                           pg_get_functiondef                           
------+------------------------------------------------------------------------

Can someone give my some advice?


Write:

Select * from function_call()

Instead of

Select function_call() 

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

David J.

pgsql-hackers by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Incremental backup from a streaming replication standby fails
Next
From: Joseph Koshakow
Date:
Subject: Re: Remove dependence on integer wrapping