Re: [SQL] example of a simple function - Mailing list pgsql-sql

From Clayton Cottingham
Subject Re: [SQL] example of a simple function
Date
Msg-id 37B8A1BF.9A9EE416@smartt.com
Whole thread Raw
In response to Re: [SQL] example of a simple function  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [SQL] example of a simple function]
List pgsql-sql
Bruce Momjian wrote:

> > can some one please send me a skeleton function, one that does nothing
> > but contains
> > all the nessecary components to hook up to pg?
> >
> > id really appreciate this ,as im not really a c/c++ programmer
> > but i really want to learn how to make these functions that call c!
> >
> >
> >
>
> There are examples in src/tutorial, I think.
>
> --
>   Bruce Momjian                        |  http://www.op.net/~candle
>   maillist@candle.pha.pa.us            |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

great!

what im trying to do is use fulltextindex, it seg faults on large dbs{mine
is currently up at 130K rows}

i really need something to this effect inn my project!

one question i have is does the *.so have to be in the ld_lib config path?
or can it just sit anywhere and be linked?

i currently just have a folder named modules under the pgsql dir
which i place my c functions in and create the function and set the path to
the lib in that dir, is this the correct procedure for doing this?
also what sort of permissions, if any are needed?








pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [SQL] example of a simple function
Next
From: "tjk@tksoft.com"
Date:
Subject: Re: [SQL] datediff function