Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject How can udf c function return table, not the rows?
Date
Msg-id CAKFQuwZbZ-j47uwOcYRquLcd0JzjkuRHtEMTF+HYH-FLmV+zYQ@mail.gmail.com
Whole thread Raw
In response to How can udf c function return table, not the rows?  ("Wen Yi" <wen-yi@qq.com>)
List pgsql-hackers
Tree view
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: Fujii Masao
Date:
Subject: Re: Add new COPY option REJECT_LIMIT
Next
From: Tomas Vondra
Date:
Subject: Re: Can we use parallel workers to create index without active/transaction snapshot?