Postgres Pro
Downloads
Home   >   mailing lists

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

From Craig Ringer
Subject Re: ERROR: query has no destination for result data
Date
Msg-id 50AF53B5.2090405@2ndQuadrant.com
Whole thread Raw
In response to ERROR: query has no destination for result data  (Peter Kroon <plakroon@gmail.com>)
Responses Re: ERROR: query has no destination for result data  (Peter Kroon <plakroon@gmail.com>)
List pgsql-general
Tree view
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 
-- Craig Ringer                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: w7 vs linux
Next
From: Peter Kroon
Date:
Subject: Re: ERROR: query has no destination for result data