Re: Bytea string operator support - Mailing list pgsql-patches

From Marko Kreen
Subject Re: Bytea string operator support
Date
Msg-id 20010906193949.A9357@l-t.ee
Whole thread Raw
In response to Bytea string operator support  ("Joe Conway" <joseph.conway@home.com>)
Responses Re: Bytea string operator support  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
On Wed, Sep 05, 2001 at 01:34:06PM -0700, Joe Conway wrote:
> > Why not just stick these things into encode() and name them
> > "my-cool-encoding" or whatever.  There is no truly natural conversion
> > between text and bytea, so encode/decode seem like the proper place.
>
> Here's a patch for bytea string functions. As discussed:
>
> text encode(bytea, 'escape')
> bytea decode(text, 'escape')

Why are you using \xxx encoding there?  As the 'escape' encoding
is supposed to be 'minimalistic' as it escapes only 2
problematic values, then IMHO it would be better to use
\0 and \\ as escapes - takes less room.


--
marko


pgsql-patches by date:

Previous
From: Rene Pijlman
Date:
Subject: Re: JDBC patch procedures (Re: Patch for jdbc2 ResultSet.java)
Next
From: Bruce Momjian
Date:
Subject: Re: Bytea string operator support