Postgres Pro
Downloads
Home   >   mailing lists

Re: extra spaces - Mailing list pgsql-general

From Roland Roberts
Subject Re: extra spaces
Date
Msg-id m2d7et6mom.fsf@tycho.rlent.pnet
Whole thread Raw
In response to extra spaces  (Soma Interesting <dfunct@telus.net>)
Responses Re: extra spaces  (Alvaro Herrera <alvherre@protecne.cl>)
List pgsql-general
Tree view 
>>>>> "Soma" == Soma Interesting <dfunct@telus.net> writes:

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

I guess I missed the orginal post about the problem, but...

Are your columns char() or varchar()?  The former is padded in
PostgreSQL but not MySQL.  The latter is what you really want.

roland
--
               PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD                             RL Enterprises
roland@rlenter.com                     76-15 113th Street, Apt 3B
rbroberts@acm.org                          Forest Hills, NY 11375

pgsql-general by date:

Previous
From: Miles Thompson
Date:
Subject: Re: [PHP-DB] extra spaces
Next
From: "Guang Mei"
Date:
Subject: Does postgresql support storage clause when creating tables