Re: query has no destination for result data

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Patta <pmuthuz(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: query has no destination for result data
Date: 2010-04-26 16:38:18
Message-ID: 4497.1272299898@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Patta <pmuthuz(at)gmail(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2010-04-26 18:38:16 Re: install both i386 and x86_64 libs
Previous Message Tom Lane 2010-04-26 16:36:41 Re: install both i386 and x86_64 libs