Received: from golem.jpl.nasa.gov (IDENT:root@hectic-1.jpl.nasa.gov
	[128.149.68.203]) by hub.org (8.9.2/8.9.1) with ESMTP id XAA91225
	for <pgsql-interfaces@postgreSQL.org>;
	Sat, 13 Feb 1999 23:30:58 -0500 (EST)
	(envelope-from lockhart@alumni.caltech.edu)
Received: from alumni.caltech.edu (localhost [127.0.0.1])
	by golem.jpl.nasa.gov (8.8.5/8.8.5) with ESMTP id EAA22233;
	Sun, 14 Feb 1999 04:30:40 GMT
Sender: tgl@mythos.jpl.nasa.gov
Message-ID: <36C65170.6AE6E97A@alumni.caltech.edu>
Date: Sun, 14 Feb 1999 04:30:40 +0000
From: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Organization: Caltech/JPL
X-Mailer: Mozilla 4.07 [en] (X11; I; Linux 2.0.36 i686)
MIME-Version: 1.0
To: Taral <taral@cyberjunkie.com>
CC: Matthew Hagerty <matthew@venux.net>, pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] (libpq question) Holy cow, what's all this fluff?!
References: <4.1.19990213182304.0095d400@mail.venux.net>
	<99021317445301.11018@taral.dobiecenter.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

> 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