Compiling a function - Mailing list pgsql-interfaces

From Matthew Hagerty
Subject Compiling a function
Date
Msg-id 4.1.19990420023358.00b5c340@mail.venux.net
Whole thread Raw
List pgsql-interfaces
Greetings,

I have a very simple function I am trying to get working with 6.2.4.  I
compiled the C program without any errors, but when I try to do a simple
query to see if it worked I get this error:

select bool2int(1 > 1);

ERROR:  Load of file /usr/local/pgsql/procs/bool2int.o failed: dlopen
(/usr/local/pgsql/procs/bool2int.o) failed

I am running on FreeBSD-3.1-RELEASE with GCC 2.7.2.1.  The command I issued
to compile was:

gcc -fpic -I../include -c bool2int.c

and the program is:

#include "../include/postgres.h"

int2 bool2int(bCondition)
bool    bCondition;
{
    if (bCondition)
        return(1);
    else
        return(0);
}

I must say thank you to Jose Soares for providing me a solution, i.e. this
function, however I cannot get it to work.

Thanks,
Matthew Hagerty

pgsql-interfaces by date:

Previous
From: Screech
Date:
Subject: Re: [INTERFACES] where did that date and time come from??
Next
From: Matthew Hagerty
Date:
Subject: Re: [INTERFACES] Compiling a function