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