Re: prepared queries in plperl - Mailing list pgsql-hackers

From Dmitry Karasik
Subject Re: prepared queries in plperl
Date
Msg-id 84psqjgcs6.fsf@tetsuo.karasik.eu.org
Whole thread Raw
In response to prepared queries in plperl  (Dmitry Karasik <dmitry@karasik.eu.org>)
List pgsql-hackers
    Hi Dmitry!

On 27 Sep 05 at 16:16, "Dmitry" (Dmitry Karasik) wrote to "Andrew Dunstan":
Andrew> Meanwhile, I will observe that this very desirable feature needsAndrew> an interface with spi_fetchrow()

I re-worked the patch ( http://www.karasik.eu.org/misc/plperl.diff ) and
now there's also spi_query_prepared(), that returns a cursor for a
previously prepared query that is to be used with subsequent spi_fetchrow()
calls.

I also modified spi_fetchrow() itself to avoid a couple of memory leaks,
and added spi_cursor_close() for cases where not all rows are fetched.

-- 
Sincerely,Dmitry Karasik



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: prefix btree implementation
Next
From: Hannu Krosing
Date:
Subject: Re: [PERFORM] A Better External Sort?