Re: ERROR: query has no destination for result data

So this means it's unable to return data?

2012/11/23 Bartosz Dmytrak <bdmytrak(at)gmail(dot)com>

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