Re: Article on MySQL vs. Postgres
Robert B. Easter <reaster@comptechnews.com>
From: "Robert B. Easter" <reaster@comptechnews.com>
To: Hannu Krosing <hannu@tm.ee>, "Robert B. Easter" <reaster@comptechnews.com>
Cc: pgsql-hackers@hub.org
Date: 2000-07-05T13:14:48Z
Lists: pgsql-hackers
On Wed, 05 Jul 2000, Hannu Krosing wrote: > "Robert B. Easter" wrote: > > -- Load the PGSQL procedural language > > -- This could also be done with the createlang script/program. > > -- See man createlang. > > CREATE FUNCTION plpgsql_call_handler() > > RETURNS OPAQUE AS '/usr/local/pgsql/lib/plpgsql.so' > > LANGUAGE 'C'; > > > > CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' > > HANDLER plpgsql_call_handler > > LANCOMPILER 'PL/pgSQL'; > > You probably meant pl/tcl as all your code is using that ? Yes, I mean't to say this: -- Load the TCL procedural language -- This could also be done with the createlang script/program. -- See man createlang. CREATE FUNCTION pltcl_call_handler() RETURNS OPAQUE AS '/usr/local/pgsql/lib/pltcl.so' LANGUAGE 'C'; CREATE TRUSTED PROCEDURAL LANGUAGE 'pltcl' HANDLER pltcl_call_handler LANCOMPILER 'PL/tcl'; -- Robert