More C function questions

Thanks for the advice so far, but I ran into another
problem:

I made what I thought was a fine object file that I
wanted to import as a function with:

CREATE FUNCTION addtwo(int4) returns int4 as
'/var/lib/pgsql/functions/tmp.so' language 'c';

Everything seemed to be fine until I go to use the
function, called addtwo(int4):

select addtwo(7) as number;

ERROR:  Load of file /var/lib/pgsql/functions/tmp.so
failed: /var/lib/pgsql/functions/tmp.so: ELF file's
phentsize not the expected size

here is my C code (tmp.c):
#include <pgsql/postgres.h>
int4 addtwo(int4);
int4 addtwo(int4 arg)
{
        return(arg+2);
}

and I used:
gcc -c tmp.c -o tmp.so
to compile.

To make sure it was working outside of PG I did a
seperate C file which called the function and that
worked by compiling the test C file like:
gcc test.c tmp.so
and the function call defined in tmp.so worked fine


Thanks again,
Jeff Davis
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com