Re: SPI_prepare, SPI_execute_plan do not return rows when using parameters

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Dennis Jenkins <dennis(dot)jenkins(at)sbcglobal(dot)net>
> writes:
> > My problem is that a query that should be
> returning a
> > row is returning zero rows when I use a
> parametrized
> > query.
>
> You're passing the wrong parameter value, and
> probably not declaring it
> to be the right type either. CHAROID is not the
> type you think it is
> (BPCHAROID is what you want), and "CStringGetDatum"
> is not the way to
> convert a C string into a char(N) datum. The most
> bulletproof way
> to do the latter is to use DirectFunctionCall3 to
> invoke bpcharin().
>

Thank you. I was able to make the code work. I
changed "CHAROID" to "BPCHAROID" and the bind[0] line
now reads:

bind[0] = DirectFunctionCall3(bpcharin,
(Datum)transit, 0 /*unused*/ , 9 + sizeof(VARHDRSZ));

However, I must admit that I could find no usable
documentation for either "DirectFunctionCall3" and
"bpcharin" online. I had to extract the source code
to the engine and read
"src/backend/utils/adt/varchar.c" to learn what
arguments to pass to DFC3.

If I create a sample stored procedure that uses the
above functions and submit it to "the documentation
people", would they want it? Would they include it in
the docs? Who are these magic people and where do I
find them?

Thank you very much for your time. Our code is now
working, so I'm a happy camper.

Dennis Jenkins