Re: Problems with Blank space - Mailing list pgsql-general

From Christopher Masto
Subject Re: Problems with Blank space
Date
Msg-id 9kpp1k$cmv$1@news.tht.net
Whole thread Raw
In response to Re: Problems with Blank space  ("Mitch Vincent" <mvincent@cablespeed.com>)
List pgsql-general
In article <00f701c11f76$dcd5b6c0$1251000a@Mitch>, "Mitch Vincent"
<mvincent@cablespeed.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) ..."?

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgresQL equivalent of NOCOUNT
Next
From: Tom Lane
Date:
Subject: Re: PostgresQL equivalent of NOCOUNT