Re: Seeking Clarification on Function Definitions in PostgreSQL Extensions

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Seeking Clarification on Function Definitions in PostgreSQL Extensions
Date: 2024-06-18 17:54:37
Message-ID: CANzqJaCWEJb8VXK=063GnE9VF71EAijXf_MCjHj48ooAyUw9bw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jun 18, 2024 at 1:16 PM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Tue, Jun 18, 2024 at 10:07 AM Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
> wrote:
>
>> fun2 puzzles me. Why would you return parameters AND *a single record* (unless
>> it's an error status).
>>
>
> You mis-understand what 2 is doing. You should go re-read the docs for
> create function again. Especially the description of rettype.
>

That's true. I've even used "RETURNS SETOF record" before.

But I stand by returning OUT params and records at the same time.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dmitry O Litvintsev 2024-06-18 17:56:53 Re: fail to install postgresql15 on Alma9
Previous Message Dmitry O Litvintsev 2024-06-18 17:48:27 Re: fail to install postgresql15 on Alma9