From: Sean Davis <sdavis2@mail.nih.gov>
To: pgsql-interfaces@postgresql.org
Cc: L Chou <leahalbany@gmail.com>
Subject: Re: the return value of select statement includes unwanted quote
Date: Mon, 9 Apr 2007 15:22:05 -0400
Message-ID: <200704091522.05914.sdavis2@mail.nih.gov> (raw)
In-Reply-To: <bbcea4060704091055y99fde8bn5c262fb087c9456e@mail.gmail.com>
References: <bbcea4060704091055y99fde8bn5c262fb087c9456e@mail.gmail.com>
On Monday 09 April 2007 13:55, L Chou wrote:
> 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.
DBI isn't doing this, I don't think. Did the data contain quotes when you
loaded them? Are the quotes present in pgAdmin III or psql?
Sean
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: sdavis2@mail.nih.gov, leahalbany@gmail.com
Subject: Re: the return value of select statement includes unwanted quote
In-Reply-To: <200704091522.05914.sdavis2@mail.nih.gov>
* 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