Re: Anonymous Code Blocks as Lambdas?

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(at)dunslane(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>