2012/11/23 Peter Kroon <plakroon@xxxxxxxxx>: > 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.stehule@xxxxxxxxx> >> >> 2012/11/23 Peter Kroon <plakroon@xxxxxxxxx>: >> > 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 <bdmytrak@xxxxxxxxx> >> >> >> >> 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 <plakroon@xxxxxxxxx> >> >>> >> >>> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
