Re: query has no destination for result data - Mailing list pgsql-novice

From Tom Lane
Subject Re: query has no destination for result data
Date
Msg-id 4497.1272299898@sss.pgh.pa.us
Whole thread Raw
In response to query has no destination for result data  (Patta <pmuthuz@gmail.com>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: install both i386 and x86_64 libs
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: install both i386 and x86_64 libs