> Just I usually prefer using fixed field lengths as queries tend to be
> significantly faster. Also, you can use them in indexes.
You are making assumptions based on other databases that are not
relevant to Postgres.
> And it leads me to wonder how you would represent an ending "space" in a
In varchar or text fields, trailing spaces are real data. In
fixed-width char fields, trailing spaces are pads. AFAIK this is
consistent with the SQL92 specification.
regards, tom lane
In response to
pgsql-jdbc by date
|Next:||From: Bruce Momjian||Date: 2001-09-07 04:30:24|
|Subject: Re: [HACKERS] JDBC pg_description update needed for CVS tip|
|Previous:||From: jeffdavey||Date: 2001-09-07 02:37:13|
|Subject: Re: Using char fields with 7.1.3 driver]|