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 >>> >> > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
