Hi
On 21 December 2012 11:54, <ta@lavabit.com> wrote:
>
> Considering Kevin’s answer I have chosen to stick with “the Postgres way”
> of resolving this, but here are some of my other rumblings that someone
> might find useful:
>
> This all is about converting part of (and interoperate with PG/database) a
> legacy app that uses ISAM-like fixed length data.
> So, data and queries come in containing a lot of trailing spaces.
>
> Possible solutions for this “trailing space” problem that I’ve come to:
I just skimmed your post, but how about this for another solution:
Create insert and update triggers to trim the data as it arrives in
the database? Will that do what you want?
--
Michael Wood <esiotrot@gmail.com>