Re: [SQL] SQL repr of bytea val

2005-06-20 Thread Michael Fuhr
On Mon, Jun 20, 2005 at 03:47:01PM +0200, Markus Bertheau ??? wrote: > > I'm constructing querys on the fly in PL/pgSQL_ and need a function that > returns the SQL representation of a bytea value. I tried encode(.., > 'escape') but it seems to return 8 bit ASCII values, not the \377 stuff > that's

[SQL] SQL repr of bytea val

2005-06-20 Thread Markus Bertheau ☭
Hi, I'm constructing querys on the fly in PL/pgSQL_ and need a function that returns the SQL representation of a bytea value. I tried encode(.., 'escape') but it seems to return 8 bit ASCII values, not the \377 stuff that's supposed to be in the bytea input syntax. Does anyone know a way to do tha