Significant trailing spaces - Mailing list pgsql-novice

From Steve Tucknott
Subject Significant trailing spaces
Date
Msg-id 1091455733.2288.4.camel@retsol1
Whole thread Raw
Responses Re: Significant trailing spaces
Re: Significant trailing spaces
help with COPY from .csv file into database
List pgsql-novice
PostGreSql 7.4.3

I noticed that there was a change in the way that 7.4 handled trailing spaces in CHAR/VARCHARS,
so upgraded from 7.2.4,
I still seem to get the same problem - putting a CHAR(250) variable (with trailing spaces) into a VARCHAR(100) gives me a VARCHAR with a length 100 - ie padded with spaces. Is this still correct?

Have I misunderstood, and are trailing spaces handled in the same way in both 7.2.4 and 7.4.3 (or is there some flag I need to set to get the new functionality?)


Regards,

Steve Tucknott

ReTSol Ltd

DDI: 01903 828769

pgsql-novice by date:

Previous
From: Joel Rodrigues
Date:
Subject: Re: [GENERAL] Fwd: contrib/xml make error on Mac OS X 10.3.4
Next
From: sql@aniota.com
Date:
Subject: import schema