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