Re: Bytea/Base64 encoders for libpq - interested? - Mailing list pgsql-hackers

From Joe Conway
Subject Re: Bytea/Base64 encoders for libpq - interested?
Date
Msg-id 00d301c13557$85b0d4f0$0705a8c0@jecw2k1
Whole thread Raw
In response to Re: Bytea/Base64 encoders for libpq - interested?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
> > On a related note, are there any other bytea functions we should have in
the
> > backend before freezing for 7.2?
>
> The SQL standards has a lot of functions for BLOB...
>

OK - thanks. I'll take a look.

> > I was thinking it would be nice to have a
> > way to cast bytea into text and vice-versa, so that the normal text
> > functions could be used for things like LIKE and concatenation.
>
> Better write a native LIKE function for bytea, now that some parts are
> threatening to make the text-LIKE function use the locale collating
> sequence.  (Multibyte aware text could also have interesting effects.)
>

Sounds like good advice. I'll try to get both the cast functions and a
native bytea LIKE function done.

-- Joe



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Table vs. row level locks confusion
Next
From: Tom Lane
Date:
Subject: Re: Postgres is eating my CPU