Обсуждение: using plpgsql outside of functions

Поиск
Список
Период
Сортировка

using plpgsql outside of functions

От
Miklos Keresztes
Дата:
Hello,
Is any way to use the plpgsql outside of functions? I
want to create a SQL script file using plpgsql for use
with pgAdmin query window.

Thanks,   Kerv


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com


Re: using plpgsql outside of functions

От
Richard Huxton
Дата:
On Wednesday 24 September 2003 16:22, Miklos Keresztes wrote:
> Hello,
> Is any way to use the plpgsql outside of functions? I
> want to create a SQL script file using plpgsql for use
> with pgAdmin query window.

No - plpgsql will only be parsed as the body of a function. You can always 
create the function, call it, then drop the function.
--  Richard Huxton Archonet Ltd