spi_query/spi_fetchrow for pl/perl

From: Abhijit Menon-Sen <ams(at)oryx(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Cc: plperlng-devel(at)pgfoundry(dot)org
Subject: spi_query/spi_fetchrow for pl/perl
Date: 2005-06-29 09:47:31
Message-ID: 20050629094731.GA21828@penne.toroid.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

The attached patch implements spi_query() and spi_fetchrow() functions
for PL/Perl, to avoid loading the entire result set into memory as the
existing spi_exec_query() function does.

Here's how one might use the new functions:

$x = spi_query("select ...");
while (defined ($y = spi_fetchrow($x))) {
...
return_next(...);
}

The changes do not affect the spi_exec_query() interface in any way.

Comments welcome.

-- ams

Attachment Content-Type Size
spi-query.diff text/plain 3.9 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Dave Page 2005-06-29 10:17:22 Re: Dbsize backend integration
Previous Message Neil Conway 2005-06-29 08:25:50 libpq: fix unlikely memory leak