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 |
-----------------------------------------------------------------------------