public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: SQL Padawan <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Simple question about running a function.
Date: Fri, 26 Nov 2021 11:39:33 -0700
Message-ID: <CAKFQuwYdtpMZZUXXy9j+jJ0VHEtTawHESw6p5H+Dac7dUt4JnA@mail.gmail.com> (raw)
In-Reply-To: <CBHeX2fE8wfCaa2pRekG8NAVM0-ZOphl6XGAnFt-ZDWMwKmnVAwunxntpLigPLZWhh64aAa3P7NpUk5Ax_1ujqUNUm4iG2HWmjhOa4s-vbk=@protonmail.com>
References: <auapJ5ZJCo1pvdzR6GK_1Fdqi7utxKRWBiCA-C0DrSZDyW5aBGNhlcvrxe4gGJOEKr6UpB7or2KwaOocBqudGlkX-OqEdriszoj5awt3ptU=@protonmail.com>
<I_azqsn6cR13UFT5V7_Q8SYvAMXs71wWZ_GvVQnTEEuNk2ilyPNKUbJsbKAaLXLindkisjBr2-7Ed1kfKsIubulp-HQCNXnRiltQiTS9rXk=@protonmail.com>
<CAKFQuwYvFhfuLiAfjef-nB-abrY12bgr4oD0we=vMkjNmoT81g@mail.gmail.com>
<CBHeX2fE8wfCaa2pRekG8NAVM0-ZOphl6XGAnFt-ZDWMwKmnVAwunxntpLigPLZWhh64aAa3P7NpUk5Ax_1ujqUNUm4iG2HWmjhOa4s-vbk=@protonmail.com>
On Friday, November 26, 2021, SQL Padawan <[email protected]>
wrote:
>
> ERROR: query has no destination for result data
> HINT: If you want to discard the results of a SELECT, use PERFORM instead.
> CONTEXT: PL/pgSQL function test_fn_6() line 6 at SQL statement
> SQL statement "SELECT test_fn_6()"
> PL/pgSQL function inline_code_block line 3 at PERFORM
>
>
Keep reading this error message until you get it. K is telling you exactly
what, where, and how to fix your problem.
David J.
view thread (7+ 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: Simple question about running a function.
In-Reply-To: <CAKFQuwYdtpMZZUXXy9j+jJ0VHEtTawHESw6p5H+Dac7dUt4JnA@mail.gmail.com>
* 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