Re: Help with SPI...

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: Help with SPI...
Дата
Msg-id 20050831042836.GA95384@winnie.fuhr.org
обсуждение исходный текст
Ответ на Help with SPI...  ("Cristian Prieto" <cristian@clickdiario.com>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Planner create a slow plan without an available index
Следующее
От: Ian Harding
Дата:
Сообщение: Re: optimum settings for dedicated box