Search Postgresql Archives

How to trim Bytea fields

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: 'PgSql General' <pgsql-general@xxxxxxxxxxxxxx>
Subject: How to trim Bytea fields
From: Howard Cole <howardnews@xxxxxxxxxxxxx>
Date: Tue, 22 Nov 2005 15:01:22 +0000
User-agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)

Hi,

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


Thanks

Howard Cole
http://www.selestial.com

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: How to trim Bytea fields
  - From: Joe Conway

Prev by Date: problem with GRANT postgres 8.0.4
Next by Date: Re: Java, postgres and jasper help
Previous by thread: problem with GRANT postgres 8.0.4
Next by thread: Re: How to trim Bytea fields
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux