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 <and...@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 > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers