extra spaces - Mailing list pgsql-general

From Soma Interesting
Subject extra spaces
Date
Msg-id 5.0.0.25.0.20001214145014.00b956c8@pop.telus.net
Whole thread Raw
Responses Re: extra spaces  (Alex Pilosov <alex@pilosoft.com>)
Re: extra spaces  ("Brett W. McCoy" <bmccoy@chapelperilous.net>)
Re: extra spaces  (Roland Roberts <roland@astrofoto.org>)
List pgsql-general
I'm using PHP & PostgreSQL.

All values called from the database are still padded with extra spaces from
the column size in the database. Is this normal - I don't remember this
happening when I was using MySQL. I thought usually the database stripped
the extra spaces when it retrieved the values.

How do you recommend dealing with this, using a PHP command to strip every
value from the database - or can I change something in the database to have
it strip the spaces auto magic like?


-          -          -          -          -          -          -
  -          -          -          -
WARNING: Some experts believe that use of any keyboard may cause
serious injury. Consult Users Guide.
                                                                                       dfunct@telus.net


pgsql-general by date:

Previous
From: Jeff MacDonald
Date:
Subject: Re: Postgres demographics?
Next
From: Alex Pilosov
Date:
Subject: Re: extra spaces