Hello
I have a idea about migration of outer (psql) variables, and custom
shell variables.
some like:
psql --allow_custom_variables --table_name=mytable
inside psql we should to use :table_name variable with "mytable" as content.
then we can use syntax
do (table_name varchar) $$
begin raise notice 'TABLENAME IS %', table_name; return;
end;
$$
so with this mechanism we can to simply parametrise plpgsql "do"
scripts from outer environment.
comments?
Regards
Pavel
2009/10/26 Andrew Dunstan <andrew@dunslane.net>:
>
>
> David E. Wheeler wrote:
>>
>> Howdy,
>>
>> Very excited about the new `DO` command in 8.5a2. I read through the patch
>> review thread and found that, like me, Dim had expected it to behave more
>> like a lambda than a simple command. And from Tom's comments, it looks like
>> it was committed in such a way to make such extensions possible (passing
>> arguments, returning values (maybe even sets?).
>>
>> So I was wondering if anyone has thought about adding such functionality,
>> and if so, what it might look like?
>>
>> If the answer is "no, because we want to see what cow paths develop in
>> 8.5," that's fine with me. I'll just be chasing cows. :-)
>>
>>
>
> It was discussed and rejected, at least for now. See earlier discussion.
>
> cheers
>
> andrew
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>