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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

the return value of select statement includes unwanted quote



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




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group