[GENERAL] Using PL/pgSQL

2006-11-14 Thread Kojak
I'm trying to install PL/pgSQL so that I can use it in a FUNCTION. I'm using PostGres 6.5.x (I know I need to upgrade...but that is another subject...). So far I've done the following: create function pgpgsql_call_handler() returns opaque as '/usr/local/pgsql/lib/plpgsql.so' language 'C'; create

Re: [GENERAL] Using PL/pgSQL

2006-11-14 Thread Martijn van Oosterhout
On Mon, Nov 13, 2006 at 01:26:08PM -0800, Kojak wrote: > I'm trying to install PL/pgSQL so that I can use it in a FUNCTION. I'm > using PostGres 6.5.x (I know I need to upgrade...but that is another > subject...). No, you need to upgrade first. 6.5 is positivly prehistoric, no-one is going to be

Re: [GENERAL] Using pl/pgsql or sql for in/out functions for types

2001-04-13 Thread Tom Lane
John Havard <[EMAIL PROTECTED]> writes: > Is there anyway to do this without having to resort to writing the > functions in C or some other language? You really cannot write datatype I/O functions in anything but C, because the I/O functions have to deal in C-style strings, which are not a SQL d