Thanks, I'll have a look at this.
2012/11/23 Pavel Stehule <pavel.steh...@gmail.com> > 2012/11/23 Peter Kroon <plakr...@gmail.com>: > > OK, but how do I run some SQL in pgAdmin with declared variables? > > pgAdmin has own client language similar to T-SQL > http://www.pgadmin.org/docs/dev/pgscript.html - but it is client side > language > > if you like server side code, then you have to write table function. > > Regards > > Pavel > > > > > > > > 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 > >> >>> > >> >> > >> > > > > > >