Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] (libpq question) Holy cow, what's all this fluff?!

From: Matthew Hagerty <matthew(at)venux(dot)net>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] (libpq question) Holy cow, what's all this fluff?!
Date: 1999-02-14 05:17:59
Message-ID: 4.1.19990214001552.009894c0@mail.venux.net (view raw or flat)
Thread:
Lists: pgsql-interfaces
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?

Matthew


In response to

pgsql-interfaces by date

Next:From: Goda AttilaDate: 1999-02-14 15:01:49
Subject: ODBC and wxWindows
Previous:From: Thomas G. LockhartDate: 1999-02-14 04:30:40
Subject: Re: [INTERFACES] (libpq question) Holy cow, what's all this fluff?!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group