Re: SPI_execute (result of a select statement)

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Jasbinder Bali <jsbali(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: SPI_execute (result of a select statement)
Date: 2006-09-01 07:52:43
Message-ID: 20060901075243.GG12644@svana.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

On Fri, Sep 01, 2006 at 03:41:12AM -0400, Jasbinder Bali wrote:
> The structure SPITupleTable is defined thus:

<snip>

> If the select query returns 10 rows (say),
> how to access the result of each row separately?

<snip>

Read this:

> >http://www.postgresql.org/docs/8.1/interactive/spi-interface-support.html

I would say that the example should clear up most of your questions:

http://www.postgresql.org/docs/8.1/interactive/spi-examples.html

Hope this helps,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-09-01 07:55:07 Re: Trigger (Transaction related)
Previous Message Jasbinder Bali 2006-09-01 07:41:12 Re: SPI_execute (result of a select statement)

Browse pgsql-novice by date

  From Date Subject
Next Message Andrew Kelly 2006-09-01 08:31:58 Re: admin technical training
Previous Message Jasbinder Bali 2006-09-01 07:41:12 Re: SPI_execute (result of a select statement)