pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
example of a simple function
4+ messages / 2 participants
[nested] [flat]

* example of a simple function
@ 1999-08-16 23:09 Clayton Cottingham <drfrog@smartt.com>
  1999-08-16 23:20 ` Re: [SQL] example of a simple function Bruce Momjian <maillist@candle.pha.pa.us>
  0 siblings, 1 reply; 4+ messages in thread

From: Clayton Cottingham @ 1999-08-16 23:09 UTC (permalink / raw)
  To: pgsql-sql

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!




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] example of a simple function
  1999-08-16 23:09 example of a simple function Clayton Cottingham <drfrog@smartt.com>
@ 1999-08-16 23:20 ` Bruce Momjian <maillist@candle.pha.pa.us>
  1999-08-16 23:41   ` Re: [SQL] example of a simple function Clayton Cottingham <drfrog@smartt.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Bruce Momjian @ 1999-08-16 23:20 UTC (permalink / raw)
  To: Clayton Cottingham <drfrog@smartt.com>; +Cc: pgsql-sql

> 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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] example of a simple function
  1999-08-16 23:09 example of a simple function Clayton Cottingham <drfrog@smartt.com>
  1999-08-16 23:20 ` Re: [SQL] example of a simple function Bruce Momjian <maillist@candle.pha.pa.us>
@ 1999-08-16 23:41   ` Clayton Cottingham <drfrog@smartt.com>
  1999-08-17 00:23     ` Re: [SQL] example of a simple function] Bruce Momjian <maillist@candle.pha.pa.us>
  0 siblings, 1 reply; 4+ messages in thread

From: Clayton Cottingham @ 1999-08-16 23:41 UTC (permalink / raw)
  To: Bruce Momjian <maillist@candle.pha.pa.us>; +Cc: 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?









^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] example of a simple function]
  1999-08-16 23:09 example of a simple function Clayton Cottingham <drfrog@smartt.com>
  1999-08-16 23:20 ` Re: [SQL] example of a simple function Bruce Momjian <maillist@candle.pha.pa.us>
  1999-08-16 23:41   ` Re: [SQL] example of a simple function Clayton Cottingham <drfrog@smartt.com>
@ 1999-08-17 00:23     ` Bruce Momjian <maillist@candle.pha.pa.us>
  0 siblings, 0 replies; 4+ messages in thread

From: Bruce Momjian @ 1999-08-17 00:23 UTC (permalink / raw)
  To: Clayton Cottingham <drfrog@smartt.com>; +Cc: pgsql-sql

> 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, Pennsylvania 19026



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~1999-08-17 00:23 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-08-16 23:09 example of a simple function Clayton Cottingham <drfrog@smartt.com>
1999-08-16 23:20 ` Bruce Momjian <maillist@candle.pha.pa.us>
1999-08-16 23:41   ` Clayton Cottingham <drfrog@smartt.com>
1999-08-17 00:23     ` Re: [SQL] example of a simple function] Bruce Momjian <maillist@candle.pha.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox