Quoting '?' placeholder in Perl's DBD::Pg?

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: pgsql-general(at)postgresql(dot)org
Subject: Quoting '?' placeholder in Perl's DBD::Pg?
Date: 2001-09-27 16:40:50
Message-ID: 3.0.5.32.20010928004050.008f1b60@192.228.128.13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi anyone know how I can quote or turn off the ? placeholder in Perl's
DBD::Pg?

I've asked on the perl modules newsgroups but I didn't get any satisfactory
answer.

Say I'm constructing a custom SQL query and it turns out that there is a ?
somewhere, how do I quote it out? It gets recognised as a placeholder by
the DBD::Pg driver.
e.g.
my $SQL=<<"EOT";
insert into blah (a,b) values ('asdad?rerwe','blah')
EOT

The ? gets interpreted as a placeholder.

Sure I can do
my $SQL=<<"EOT";
insert into blah (a,b) values (?,?)
EOT

And do the execute thing. But if the number of columns changes from query
to query, and so on it might be less convenient to use placeholders.

If it really can't be done, then yeah I'll use placeholders. But it seems
strange if you can't.

Cheerio,
Link.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2001-09-27 16:41:02 Re: New To PostgreSQL
Previous Message Lincoln Yeoh 2001-09-27 16:23:47 Re: Encoding passwords