On Fri, 03 Aug 2001 21:29, David Lizano wrote:
> Hi,
>
> How can I activate the plsql language from a SQL environment in PostgreSQL
> 7.1?
>
> I know the command line command "createlang", but I would like to use a SQL
> syntax. I have been trying with the SQL command "CREATE LANGUAGE", but I
> don't know how to do it.
CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS
'/opt/pgsql/lib/plpgsql.so' LANGUAGE 'C';
^^^^^^^^^^^^^
make sure you get this path correct.
CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER
"plpgsql_call_handler" LANCOMPILER 'PL/pgSQL';
have fun!
--
Sincerely etc.,
NAME Christopher SawtellCELL PHONE 021 257 4451ICQ UIN 45863470EMAIL csawtell @ paradise . net . nzCNOTES
ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz
-> Please refrain from using HTML or WORD attachments in e-mails to me <-