| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Cristian Prieto <cristian(at)clickdiario(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Help with SPI... |
| Date: | 2005-08-31 04:28:36 |
| Message-ID: | 20050831042836.GA95384@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Harding | 2005-08-31 04:43:19 | Re: optimum settings for dedicated box |
| Previous Message | Alvaro Herrera | 2005-08-31 04:04:02 | Re: Planner create a slow plan without an available index |