the return value of select statement includes unwanted quote

Поиск
Список
Период
Сортировка
От L Chou
Тема the return value of select statement includes unwanted quote
Дата
Msg-id bbcea4060704091055y99fde8bn5c262fb087c9456e@mail.gmail.com
обсуждение исходный текст
Ответы Re: the return value of select statement includes unwanted quote
Список pgsql-interfaces
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
doublequote 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
thevalue has extra two double quote around it, and it doesn't match any record in the database.  <br /><br />Please
adviseif there is any way to remove the double quote.  <br /><br />Thanks, <br /><br />Leah<br /><br /><br /> 

В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: How do I get started?
Следующее
От: Tonnerre LOMBARD
Дата:
Сообщение: Index "misbehavior" in PostgreSQL 8.2.2?