Postgres Pro
Downloads
Home   >   mailing lists

Thread: example of a simple function

example of a simple function

From
Clayton Cottingham
Date:
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!

Re: [SQL] example of a simple function

From
Bruce Momjian
Date:
> 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,
Pennsylvania19026

Re: [SQL] example of a simple function

From
Clayton Cottingham
Date:
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?

Re: [SQL] example of a simple function]

From
Bruce Momjian
Date:
> 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 think in the path.

> 
> 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?

I don't remember.

--  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,
Pennsylvania19026