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
---(end of broadcast)---
TIP 6: explain analyze is your friend
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
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
---(end of broadcast)---
