Re: ERROR: query has no destination for result data

[Peter Kroon <plakroon@xxxxxxxxx>]

So this means it's unable to return data?

2012/11/23 Bartosz Dmytrak <bdmytrak@xxxxxxxxx>

Hi,

according to doc: http://www.postgresql.org/docs/9.2/static/sql-do.html

DO returns void:

"The code block is treated as though it were the body of a function with no parameters, returning void."

Regars

Bartek

Pozdrawiam,
Bartek

2012/11/23 Peter Kroon <plakroon@xxxxxxxxx>

Hello,

I wish to return the SELECT statement.

Ho can I achieve this?

DO $$

DECLARE v_some_id int=14;

BEGIN

/*

more queries here...

*/

SELECT 'this is text';

END 

$$ LANGUAGE plpgsql;

Best,

Peter Kroon