Re: ERROR: query has no destination for result data

From: Craig Ringer <craig(at)2ndQuadrant(dot)com>
To: Peter Kroon <plakroon(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: query has no destination for result data
Date: 2012-11-23 10:45:09
Message-ID: 50AF53B5.2090405@2ndQuadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/23/2012 06:36 PM, Peter Kroon wrote:
> Hello,
>
> I wish to return the SELECT statement.
> Ho can I achieve this?

RETURN QUERY.

See
http://www.postgresql.org/docs/current/static/plpgsql-control-structures.html
<http://www.postgresql.org/docs/9.2/static/plpgsql-control-structures.html>

--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Kroon 2012-11-23 10:53:58 Re: ERROR: query has no destination for result data
Previous Message Craig Ringer 2012-11-23 10:42:43 Re: w7 vs linux