From: | Srinivas Iyyer <srini_iyyer_bio(at)yahoo(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | problem with single quote : ' |
Date: | 2006-08-22 17:44:09 |
Message-ID: | 20060822174410.33124.qmail@web38110.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Dear group,
In one of my tables, the varchar data includes
single-quotes.
Example:
3',5'-cyclic-nucleotide phosphodiesterase
I populated tables by introducing \ in front of '
Example:
3\',5\'-cyclic-nucleotide phosphodiesterase
I am using R to query and analyze the data and it is
turning out to be a problem to get a character vector
in R to have the output like this:
EXECUTE count_fterm_sql('3\',5\'-cyclic-nucleotide
phosphodiesterase activity');
somehow it always provides me
EXECUTE count_fterm_sql('3\\',5\\'-cyclic-nucleotide
phosphodiesterase activity');
The above query with two \\ does not work in postgres.
I tried a variety of tricks in R to get to what I want
that suits postgres. No luck.
so I decided to substitute where ever I find instances
of ' (i.e: 3', 10', esterase's etc) to "prime".
Eg: 3prime, 10prime, esterasesprimes.
I have all my data in table gobe. I dont know how many
rows have ' character.
how can I substitute ' with prime in the whole table.
BTW, is this a good way to solve the problem. For
instance bioinformatics people who are dealing with GO
terms, how are they approaching this problem.
PS: Dear Sean, what is your opinion. did you ever
come across this problem. Do you have any solution in
R.
thanks
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Jasbinder Bali | 2006-08-22 17:48:06 | Passing Arguments to a trigger function(Problem) |
Previous Message | A. Kretschmer | 2006-08-22 16:21:51 | Re: response time data |