At 04:30 AM 2/14/99 +0000, Thomas G. Lockhart wrote:
>> You want a varchar (or is it bpchar?), not a char. char(x) will always
>> return x characters, with space padding if necessary.
>"bpchar" == "blank padded char", which is what char() is mapped to
>internally. As Matthew has already learned, he probably really wants to
>be using varchar(), or fix it up with trim().
> - Tom
Yeah, but the docs say you get a performance hit for using varchar, text,
and the like. Which is worse, the database performance hit or the extra
call to trim for every char field?
In response to
pgsql-interfaces by date
|Next:||From: Goda Attila||Date: 1999-02-14 15:01:49|
|Subject: ODBC and wxWindows|
|Previous:||From: Thomas G. Lockhart||Date: 1999-02-14 04:30:40|
|Subject: Re: [INTERFACES] (libpq question) Holy cow, what's all this fluff?!|