From: Peter Willis <peterw@borstad.com>
To: pgsql-sql@postgresql.org
Subject: FUNCTION problem
Date: Wed, 01 Apr 2009 16:31:20 -0700
Message-ID: <49D3F948.4060908@borstad.com> (raw)
Hello,
I am having a problem with a FUNCTION.
The function creates just fine with no errors.
However, when I call the function postgres produces an error.
Perhaps someone can enlighten me.
--I can reproduce the error by making a test function
--that is much easier to follow that the original:
CREATE OR REPLACE FUNCTION test_function(integer)
RETURNS SETOF RECORD AS
$BODY$
DECLARE croid integer;
BEGIN
--PERFORM A SMALL CALCULATION
--DOESNT SEEM TO MATTER WHAT IT IS
SELECT INTO croid 2;
--A SELECT STATEMENT OUTPUTS RECORDS (one in this case)
SELECT croid,$1;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
--The call looks like the following:
SELECT test_function(1);
--The resulting error reads as follows:
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_function" line 5 at SQL statement
********** Error **********
ERROR: query has no destination for result data
SQL state: 42601
Hint: If you want to discard the results of a SELECT, use PERFORM instead.
Context: PL/pgSQL function "test_function" line 5 at SQL statement
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: pgsql-sql@postgresql.org
Cc: peterw@borstad.com
Subject: Re: FUNCTION problem
In-Reply-To: <49D3F948.4060908@borstad.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox