OK, but how do I run some SQL in pgAdmin with declared variables?
2012/11/23 Pavel Stehule <pavel.steh...@gmail.com> > 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 > >>> > >> > > >
