Re: [GENERAL] Space stripping ...

On Fri, 24 Jul 1998, Davide Libenzi wrote:

> Is there a way to avoid the trailing blanks from char fields ?

TRIM() I think.

> Why PostgreSQL store the full field on storage even if it's almost empty ?

Cos that's how the char() type is supposed to work. You could ofcourse
use varchar(), which will only take the space it needs, in change for
some performance.

Maarten

_____________________________________________________________________________
| TU Delft, The Netherlands, Faculty of Information Technology and Systems  |
|                   Department of Electrical Engineering                    |
|           Computer Architecture and Digital Technique section             |
|                          M.Boekhold@et.tudelft.nl                         |
-----------------------------------------------------------------------------