So this means it's unable to return data?
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 >> >> >
