Postgres Pro
Downloads
Home   >   mailing lists

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

From Adrian Klaver
Subject Re: ERROR: query has no destination for result data
Date
Msg-id 50AF8DDB.3040400@gmail.com
Whole thread Raw
In response to Re: ERROR: query has no destination for result data  (Peter Kroon <plakroon@gmail.com>)
List pgsql-general
Tree view 
On 11/23/2012 03:25 AM, Peter Kroon wrote:
> Yes, but this means I have to create a function which is something I
> don't want.
> I just want to debug some of my code in the related function.
> So what I want is in pgAdmin declare some vars and run the sql and get
> the result.

The way I handle this is to use RAISE NOTICE in place of RETURN.

>


--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: [BUGS] Prepared Statement Name Truncation
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] Prepared Statement Name Truncation