Of course, here is the solution I used (to create a C function to link to with PG): '$' means done at command prompt '=>' means done at psql prompt this was done in Linux (RedHat 6.1) with PG 6.5 and gcc 1) I made the C source file, file.c, which included postgres.h 2) compiled as object: $ gcc -fpic -c -o file.o file.c $ ld -Bshareable -o file.so file.o 3) added function with SQL: => create function function_name(int4,float) returns float AS '/path/to/file.so' language 'c'; 4) test function with SQL: => select function_name(7,8.3) as number; Hope this helps someone, Jeff Davis PS: If I get a good array function written (which I am working on now) I will contribute that as well. __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com ************
