Adding an example of how to insert array data using a prepared statement (issue #145)

ged · ged · commit 8619ef0f40d4 · 2012-10-30T12:41:19.000-07:00
diff --git a/sample/array_insert.rb b/sample/array_insert.rb
@@ -0,0 +1,20 @@
+#!/usr/bin/env ruby
+
+require 'pg'
+
+c = PG.connect( dbname: 'test' )
+
+# this one works:
+c.exec( "DROP TABLE IF EXISTS foo" )
+c.exec( "CREATE TABLE foo (strings character varying[]);" )
+
+# But using a prepared statement works:
+c.set_error_verbosity( PG::PQERRORS_VERBOSE )
+c.prepare( 'stmt', "INSERT INTO foo VALUES ($1);" )
+
+# This won't work
+#c.exec_prepared( 'stmt', ["ARRAY['this','that']"] )
+
+# but this will:
+c.exec_prepared( 'stmt', ["{'this','that'}"] )
+
