how to use plpgsql ?

Started by Jinsoo Hwangover 25 years ago2 messagesgeneral
Jump to latest
#1Jinsoo Hwang
jshwang@anova.inha.ac.kr

Hi,
I just installed ver.7.0.2 on Solaris2.7 and start experimenting.
But I was wondering how to use PL/pgSQL ?
I followed the examples on the documentation but it doesn't work.
Do I have to do createlang plpgsql ?
How to load PL/pgSQL ? I installed the source as in the INSTALL
file says.

Thanks in advance.

p.s.: please forward the answer directly to my email address.

#2Anatoly K. Lasareff
tolik@aaanet.ru
In reply to: Jinsoo Hwang (#1)
Re: how to use plpgsql ?

"JH" == Jinsoo Hwang <jshwang@anova.inha.ac.kr> writes:

JH> Hi,
JH> I just installed ver.7.0.2 on Solaris2.7 and start experimenting.
JH> But I was wondering how to use PL/pgSQL ?
JH> I followed the examples on the documentation but it doesn't work.
JH> Do I have to do createlang plpgsql ?
JH> How to load PL/pgSQL ? I installed the source as in the INSTALL
JH> file says.

JH> Thanks in advance.

JH> p.s.: please forward the answer directly to my email address.

Yes, you have do 'createlang plpgsql' command. After installation you
have 'C' and 'sql' languages only. 'createlanguage' command creates
language handler and language itself - like examples in doc.

--
Anatoly K. Lasareff Email: tolik@aaanet.ru