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

Re: the return value of select statement includes unwanted quote

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: pgsql-interfaces(at)postgresql(dot)org
Cc: "L Chou" <leahalbany(at)gmail(dot)com>
Subject: Re: the return value of select statement includes unwanted quote
Date: 2007-04-09 19:22:05
Message-ID: 200704091522.05914.sdavis2@mail.nih.gov (view raw or flat)
Thread:
Lists: pgsql-interfaces
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

In response to

pgsql-interfaces by date

Next:From: Raimon FernandezDate: 2007-04-17 09:22:19
Subject: Implementing Frontend/Backend Protocol
Previous:From: L ChouDate: 2007-04-09 17:55:22
Subject: the return value of select statement includes unwanted quote

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