Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id C005A9FA49D
	for <pgsql-interfaces-postgresql.org@postgresql.org>;
	Mon,  9 Apr 2007 14:55:30 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 45393-06 for
	<pgsql-interfaces-postgresql.org@postgresql.org>;
	Mon,  9 Apr 2007 14:55:23 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.173])
	by postgresql.org (Postfix) with ESMTP id 8767B9FA601
	for <pgsql-interfaces@postgresql.org>;
	Mon,  9 Apr 2007 14:55:24 -0300 (ADT)
Received: by ug-out-1314.google.com with SMTP id k3so1493600ugf
	for <pgsql-interfaces@postgresql.org>;
	Mon, 09 Apr 2007 10:55:23 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
	b=Hn485EoZn50UYt5VYdtLJKzNnchkoDZ8iF5XYmNz1lUu+zdvu4kb+Oud+eSJ0hBkuAw/yAM5NGjJcr0kXOSGLexkWZtgh+NeEQBn39DdLL7A1EF0DV11oW7rWHaFEtL72E6ZfwOL4mAR1jkvdBW6W0GvrF3xNDal2ydB1k3TEmw=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=kgY+MXD1h2eUXbUXd9sgmfchxIjgA/0QpfSsYcbx8GewJr/sgNtmgJUN2ujvODSZ4g63GQ3mjHNJmXKLVFf7/wAnm9pj58kYIpSXZVuUkSGC+7gw7GyQznkr1ys+bZctzGk09wWKBhjoyrLf3ogEr9XmRvlb0u9Pu49DKR4sz4c=
Received: by 10.67.31.17 with SMTP id i17mr4166844ugj.1176141323029;
	Mon, 09 Apr 2007 10:55:23 -0700 (PDT)
Received: by 10.66.236.1 with HTTP; Mon, 9 Apr 2007 10:55:22 -0700 (PDT)
Message-ID: <bbcea4060704091055y99fde8bn5c262fb087c9456e@mail.gmail.com>
Date: Mon, 9 Apr 2007 13:55:22 -0400
From: "L Chou" <leahalbany@gmail.com>
To: pgsql-interfaces@postgresql.org
Subject: the return value of select statement includes unwanted quote
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_11609_20924893.1176141322972"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200704/5
X-Sequence-Number: 6493

------=_Part_11609_20924893.1176141322972
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi, I am writing perl code and using DBI to connect to the postgreSQL
database.  I found that if the column type is varchar, then the return value
of this column will always be double quoted.   Is there a way that I could
remove the double quote from the return value?  since if I use a compound
statement and used the return value to query the database, then PostgreSQL
doen't recognize the double quote.  If I put extra single quote around the
return value, then the value has extra two double quote around it, and it
doesn't match any record in the database.

Please advise if there is any way to remove the double quote.

Thanks,

Leah

------=_Part_11609_20924893.1176141322972
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi, I am writing perl code and using DBI to connect to the postgreSQL database.&nbsp; I found that if the column type is varchar, then the return value of this column will always be double quoted.&nbsp;&nbsp; Is there a way that I could remove the double quote from the return value?&nbsp; since if I use a compound statement and used the return value to query the database, then PostgreSQL doen&#39;t recognize the double quote.&nbsp; If I put extra single quote around the return value, then the value has extra two double quote around it, and it doesn&#39;t match any record in the database.&nbsp; 
<br><br>Please advise if there is any way to remove the double quote.&nbsp; <br><br>Thanks, <br><br>Leah<br><br><br>

------=_Part_11609_20924893.1176141322972--