query has no destination for result data

From: Patta <pmuthuz(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: query has no destination for result data
Date: 2010-04-23 22:22:23
Message-ID: i2nd6d29ae21004231522yd302e5b3h3b1d0de9091ddc6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I'm a beginner in postgresql. I get the below error. Could you help me
to fix this one?

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 "insertcommjunction1" line 7 at SQL statement

The function is as follows.
CREATE OR REPLACE FUNCTION test()
RETURNS text AS
$BODY$
DECLARE
query_rec record;
idxfti tsvector;
c1 cursor for select * from <table>;
Begin
open c1;
Loop
fetch c1 into query_rec;
begin
raise notice 'Record %', query_rec.field1;
end;
End loop;
Return 'ok';
end;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Giancarlo Boaron 2010-04-23 22:26:26 Problems with pg_prepare
Previous Message Giancarlo Boaron 2010-04-23 22:21:12