Message-ID: <49D3F948.4060908@borstad.com>
Date: Wed, 01 Apr 2009 16:31:20 -0700
From: Peter Willis <peterw@borstad.com>
Reply-To: peterw@borstad.com
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: FUNCTION problem
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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