From: L Chou <leahalbany@gmail.com>
To: pgsql-interfaces@postgresql.org
Subject: the return value of select statement includes unwanted quote
Date: Mon, 9 Apr 2007 13:55:22 -0400
Message-ID: <bbcea4060704091055y99fde8bn5c262fb087c9456e@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: leahalbany@gmail.com
Subject: Re: the return value of select statement includes unwanted quote
In-Reply-To: <bbcea4060704091055y99fde8bn5c262fb087c9456e@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox