2012/11/23 Pavel Stehule <pavel.stehule@xxxxxxxxx>
2012/11/23 Peter Kroon <plakroon@xxxxxxxxx>:
> So this means it's unable to return data?yes, it means :(
DO "is" void function, so you cannot to return anything
Regards
Pavel Stehule
>
>
> 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
>>>
>>
>
