Re: Activation of plsql

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 Sawtell
CELL PHONE 021 257 4451
ICQ UIN 45863470
EMAIL csawtell @ paradise . net . nz
CNOTES 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 <-