Re: Help with SPI... - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Help with SPI...
Date
Msg-id 20050831042836.GA95384@winnie.fuhr.org
Whole thread Raw
In response to Help with SPI...  ("Cristian Prieto" <cristian@clickdiario.com>)
List pgsql-general
On Tue, Aug 30, 2005 at 01:28:11PM -0600, Cristian Prieto wrote:
> Well, the new value is really the content of a memory segment, I
> know I could store it again using SPI and an UPDATE statement, but
> that means that I need to transform the val value into a string,
> and I don't know the length of the string with the scape characters
> added.

You could use SPI_prepare() and SPI_execp() without having to
transform the bytea value into a string; see the SPI documentation
and look around for examples that use numbered parameters ($1, $2,
etc.).

--
Michael Fuhr

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Planner create a slow plan without an available index
Next
From: Ian Harding
Date:
Subject: Re: optimum settings for dedicated box