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

public inbox for [email protected]  
help / color / mirror / Atom feed

From: =?utf-8?B?V2VuIFlp?= <[email protected]>
To: =?utf-8?B?RGF2aWQgRy4gSm9obnN0b24=?= <[email protected]>
Cc: =?utf-8?B?cGdzcWwtaGFja2Vycw==?= <[email protected]>
Subject: Re:How can udf c function return table, not the rows?
Date: Sat, 20 Jul 2024 07:26:46 +0800
Message-ID: <[email protected]> (raw)

You're right, thanks!








Wen&nbsp;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.

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re:How can udf c function return table, not the rows?
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox