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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org