On 11/23/10 12:34 PM, akp geek wrote:
Hi -
This is related to my earlier post. For the function I am
passing a string. But the string some time has a single quote inside
the string like "IT's a String Test" , How can I handle that, can you
please help?
at the SQL level, pass it as a parameter.
like, in perl...
my $sth = $dbh->prepare('select test_repl(?);');
$sth->execute("It's a String Test");
(or my $sth->execute('It\'s a String Test'); ...)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
