Re: ERROR: query has no destination for result data

Thanks, I'll have a look at this.

2012/11/23 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>

> 2012/11/23 Peter Kroon <plakroon(at)gmail(dot)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(dot)stehule(at)gmail(dot)com>
> >>
> >> 2012/11/23 Peter Kroon <plakroon(at)gmail(dot)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 <bdmytrak(at)gmail(dot)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 <plakroon(at)gmail(dot)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
> >> >>>
> >> >>
> >> >
> >
> >
>