[GENERAL] How to use PQfn() in libpq library?

[Bruce YUAN]

Hi All,

How to use PQfn() in libpq library?

#include 
PGresult *PQfn(PGconn* conn,
   int fnid,
   int *result_buf,
   int *result_len,
   int result_is_int,
   const PQArgBlock *args,
   int nargs);
Who can share a detailed example source code? Which server functions can be
executed from client?
Many thanks!

Bruce

Re: [GENERAL] How to use PQfn() in libpq library?

[Bruce YUAN]

Hi Tom,

Which interface will replace this? And where can get it's reference?
Best regards,
Bruce
2009/6/19 Tom Lane 

> Bruce YUAN  writes:
> > How to use PQfn() in libpq library?
>
> Look into src/interfaces/libpq/fe-lobj.c for several examples.
> However, please note the comment in the documentation:
>
>This interface is somewhat obsolete, as one can achieve similar
>performance and greater functionality by setting up a prepared
>statement to define the function call.  Then, executing the statement
>with binary transmission of parameters and results substitutes for a
>fast-path function call.
>
> > Which server functions can be
> > executed from client?
>
> Anything you could call normally can be called this way too.
>
>regards, tom lane
>

Re: [GENERAL] How to use PQfn() in libpq library?

[Bruce YUAN]

Oh. Many thanks!
Bruce
2009/6/20 Alvaro Herrera 

> Bruce YUAN escribió:
> > Hi Tom,
> >
> > Which interface will replace this? And where can get it's reference?
>
> Try reading beyond the comma in the quoted paragraph:
>
> > >This interface is somewhat obsolete, as one can achieve similar
> > >performance and greater functionality by setting up a prepared
> > >statement to define the function call.  Then, executing the
> statement
> > >with binary transmission of parameters and results substitutes for a
> > >fast-path function call.
>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/ <http://www.commandprompt.com/>
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>

[GENERAL] About fastpath function call

[Bruce YUAN]

Hi, All

I hope to call some backend function via PQfn(), such as hash and nbtree.
Can we do it? How to do? Many thanks.

Best regards,
Bruce