Обсуждение: How to trim Bytea fields

Hi,

I have an bytea field that contains data with a lot of trailing blank
space composed of multiple '\000' zero bytes. Does anyone know of a
quick SQL fix to trim these bytes from the data?

Thanks

Howard Cole
http://www.selestial.com

Howard Cole wrote:
> Hi,
>
> I have an bytea field that contains data with a lot of trailing blank
> space composed of multiple '\000' zero bytes. Does anyone know of a
> quick SQL fix to trim these bytes from the data?

trim() will remove '\000' bytes from both ends -- would that work for you?

select trim('\\000'::bytea from '\\00012\\00034\\000\\000'::bytea);
   btrim
----------
  12\00034
(1 row)

Joe

Joe Conway wrote

> trim() will remove '\000' bytes from both ends -- would that work for
> you?

Thanks Joe, just what I was looking for.

Howard