Обсуждение: query has no destination for result data
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;
On Friday 23 April 2010, Patta <pmuthuz@gmail.com> wrote: > 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; Just do something like: FOR query_rec IN SELECT * FROM <table> LOOP ... actions END LOOP; pl/pgsql will use a cursor internally without you worrying about it. -- "No animals were harmed in the recording of this episode. We tried but that damn monkey was just too fast."
Patta <pmuthuz@gmail.com> writes: > 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() Um, that's not the function being complained of ... regards, tom lane