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
  |