DO "is" void function, so you cannot to return anything
Regards Pavel Stehule
> > > 2012/11/23 Bartosz Dmytrak <bdmytrak@gmail.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@gmail.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 >>> >> >
