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

From Joe Conway
Subject Re: Bytea string operator support
Date
Msg-id 012701c136fe$ece22040$0705a8c0@jecw2k1
Whole thread Raw
In response to Re: Bytea string operator support  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
> > > 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.
>
> Agreed, and I have documented this in the SGML pages.  Knowing this,
> bytea becomes a much easier format to use.

No problem -- I kind of like the octal style better, but I can see your
point. I'll wait for awhile for more comments, and then send in a new patch.

-- Joe



pgsql-patches by date:

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