2012/11/23 Peter Kroon <plakr...@gmail.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 <bdmyt...@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 <plakr...@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 >>> >> > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
