Hey Kenneth,
There are three benefits:
>
> - reduces the CPU overhead in both the client and the DB server
> for converting to/from ASCII numbers
>
You solution based on PL/pgSQL function. I am doubt that execution
of PL/pgSQL parser (loadable module, which aren't built into the
PostgreSQL server
On Thu, Sep 30, 2010 at 10:30:16PM +0400, Dmitriy Igrishin wrote:
> Hey Kenneth,
>
> Thank you for solution. But sorry, personally, I don't clearly
> understand the benefits of this code compared with using
> simple array literals or even array constructors...
> Conversion "overheads" from text? D
Hey Kenneth,
Thank you for solution. But sorry, personally, I don't clearly
understand the benefits of this code compared with using
simple array literals or even array constructors...
Conversion "overheads" from text? Doubtfully...
--
// Dmitriy.
quot; option to keep the alignment
from being padded in the structure to 8 bytes, which messed up the
binary encoding of the array. Please let me know if you have any
questions.
Regards,
Ken
On Wed, Sep 22, 2010 at 12:07:15PM +0200, Steve wrote:
>
> Original-Nachricht
>
Original-Nachricht
> Datum: Sun, 12 Sep 2010 01:52:04 +0400
> Von: Dmitriy Igrishin
> An: Steve
> CC: pgsql-sql@postgresql.org
> Betreff: Re: [SQL] Question about PQexecParams
> Hey Steve,
>
> 2010/9/11 Steve
>
> > Hello list,
> >
&
Hey Steve,
2010/9/11 Steve
> Hello list,
>
> I would like to call a function from my C application by using libpq and
> PQexecParams. My problem is that I don't know how to specify that I want to
> send an array to the function.
>
> Assume the function is called lookup_data and takes the followi
Hello list,
I would like to call a function from my C application by using libpq and
PQexecParams. My problem is that I don't know how to specify that I want to
send an array to the function.
Assume the function is called lookup_data and takes the following parameters:
lookup_data(integer,inte
