From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Peter Kroon <plakroon(at)gmail(dot)com> |
Cc: | Bartosz Dmytrak <bdmytrak(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: ERROR: query has no destination for result data |
Date: | 2012-11-23 10:58:35 |
Message-ID: | CAFj8pRB8pL8QrjwH5mYiuP2bmHEe-Z8cVSL1ioYDLYXMwmidNQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2012/11/23 Peter Kroon <plakroon(at)gmail(dot)com>:
> 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(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
>>>
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Euler Taveira | 2012-11-23 11:00:28 | Re: Prepared Statement Name Truncation |
Previous Message | Craig Ringer | 2012-11-23 10:56:34 | Re: ERROR: query has no destination for result data |