In article <00f701c11f76$dcd5b6c0$1251000a(at)Mitch>, "Mitch Vincent"
<mvincent(at)cablespeed(dot)com> wrote:
> Yes, if you're using fixed-length fields then the value is padded out to
> the length that the field is fixed to :-)
>
> I'm sure Perl has some facility for stripping NULLs off of strings, I
> suggest using it here or changing the data type in PG...
What's wrong with "SELECT TRIM(col) ..."?