Solution

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