| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raimon Fernandez | 2007-04-17 09:22:19 | Implementing Frontend/Backend Protocol |
| Previous Message | L Chou | 2007-04-09 17:55:22 | the return value of select statement includes unwanted quote |