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
>
>