Received: from antares.mcs.anl.gov (mcs.anl.gov [140.221.9.6]) by hub.org (8.9.3/8.9.3) with SMTP id QAA17374 for ; Sun, 16 May 1999 16:23:17 -0400 (EDT) (envelope-from selkovjr@xnet.com) Received: from xnet.com (selkovjr@selkovjr.xnet.com [205.243.141.67]) by antares.mcs.anl.gov (8.6.10/8.6.10) with ESMTP id PAA16291; Sun, 16 May 1999 15:23:15 -0500 Message-Id: <199905162023.PAA16291@antares.mcs.anl.gov> To: "fabian baena" , pgsql-general@postgreSQL.org From: selkovjr@mcs.anl.gov Subject: Re: [GENERAL] Trying to make functions in 'C' In-Reply-To: Your message of "Sun, 16 May 1999 11:23:25 +0700." <19990516162326.84206.qmail@hotmail.com> Date: Sun, 16 May 1999 15:24:24 -0400 Sender: selkovjr@xnet.com > I'm tying to learn how to make function in 'C'. > I'm trying to compile a program I made in 'C'. > The command I gave were: > > % gcc -fPIC -c addone.c -I/usr/local/pgsql/include > % ld -G -Bdynamic -o addone.so addone.o > > and created the function in postgres like this: > > CREATE FUNCTION add_one(int4) RETURNS int4 > AS './addone.so' LANGUAGE 'c'; ^^^^^^^^^^^^^ one must provide an absolute path here --Gene