| From: | Maarten Boekhold <maartenb(at)dutepp0(dot)et(dot)tudelft(dot)nl> |
|---|---|
| To: | Davide Libenzi <dlibenzi(at)maticad(dot)it> |
| Cc: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] Space stripping ... |
| Date: | 1998-07-24 08:01:46 |
| Message-ID: | Pine.SUN.3.91.980724100044.4169H-100000@dutepp0.et.tudelft.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)Boekhold(at)et(dot)tudelft(dot)nl |
-----------------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Davide Libenzi | 1998-07-24 08:15:29 | Space stripping ... |
| Previous Message | Maarten Boekhold | 1998-07-24 07:46:08 | Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux] |