Postgres Pro
Downloads
Home   >   mailing lists

Re: Simple question about running a function. - Mailing list pgsql-novice

From David G. Johnston
Subject Re: Simple question about running a function.
Date
Msg-id CAKFQuwYdtpMZZUXXy9j+jJ0VHEtTawHESw6p5H+Dac7dUt4JnA@mail.gmail.com
Whole thread Raw
In response to Re: Simple question about running a function.  (SQL Padawan <sql_padawan@protonmail.com>)
List pgsql-novice
Tree view
On Friday, November 26, 2021, SQL Padawan <sql_padawan@protonmail.com> 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.
 

pgsql-novice by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Simple question about running a function.
Next
From: Greg Rychlewski
Date:
Subject: Table-Level Locks and Transactions