On Friday 23 April 2010, Patta <pmuthuz(at)gmail(dot)com> wrote:
> 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
> The function is as follows.
> CREATE OR REPLACE FUNCTION test()
> RETURNS text AS
> query_rec record;
> idxfti tsvector;
> c1 cursor for select * from <table>;
> open c1;
> fetch c1 into query_rec;
> raise notice 'Record %', query_rec.field1;
> End loop;
> Return 'ok';
> LANGUAGE 'plpgsql' VOLATILE;
Just do something like:
FOR query_rec IN SELECT * FROM <table>
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."
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2010-04-26 16:36:41|
|Subject: Re: install both i386 and x86_64 libs |
|Previous:||From: Atif Jung||Date: 2010-04-26 11:37:45|