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

Re: problem with single quote : '

From: Brian Hurt <bhurt(at)janestcapital(dot)com>
To: Srinivas Iyyer <srini_iyyer_bio(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: problem with single quote : '
Date: 2006-08-22 17:52:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Srinivas Iyyer wrote:

>Dear group, 
> In one of my tables, the varchar data includes
>3',5'-cyclic-nucleotide phosphodiesterase
>I populated tables by introducing \ in front of ' 
>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. 

A better solution might be to use $_$ instead of ' to quote strings.  If 
you use $_$, you don't need to escape '. 

# select $_$Foo'bar$_$;
(1 row)


Note that you can use any sequence of alphabetical characters or 
underscores to do quotes- so
is the quoted string $_$'$_$.


In response to


pgsql-novice by date

Next:From: Cyrus DowneyDate: 2006-08-22 17:58:08
Subject: Re: problem with single quote : ' [VASCL:A111C2C2718]
Previous:From: Jasbinder BaliDate: 2006-08-22 17:48:06
Subject: Passing Arguments to a trigger function(Problem)

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