Author: turnstep
Date: Tue Sep 15 10:25:21 2009
New Revision: 13343
Modified:
DBD-Pg/trunk/Pg.pm
Log:
Better quote example.
Modified: DBD-Pg/trunk/Pg.pm
==============================================================================
--- DBD-Pg/trunk/Pg.pm (original)
+++ DBD-Pg/trunk/Pg.pm Tue Sep 15 10:25:21 2009
@@ -2688,7 +2688,10 @@
exported by DBD::Pg (such as PG_BYTEA). In addition to string, bytea, char, bool,
and other standard types, the following geometric types are supported: point, line,
lseg, box, path, polygon, and circle (PG_POINT, PG_LINE, PG_LSEG, PG_BOX,
-PG_PATH, PG_POLYGON, and PG_CIRCLE respectively).
+PG_PATH, PG_POLYGON, and PG_CIRCLE respectively). To quote a Postgres-specific
+data type, you must use a 'hashref' argument like so:
+
+ my $quotedval = $dbh->quote($value, { pg_type => PG_VARCHAR });
B<NOTE:> The undocumented (and invalid) support for the C<SQL_BINARY> data
type is officially deprecated. Use C<PG_BYTEA> with C<bind_param()> instead:
lmpx.com only provides a reader for public news (NNTP) servers. It is not
affiliated with the servers or forums shown here and is not responsible for
the content of articles, which is written by their respective authors.