pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Erik Rijkers <er@xs4all.nl>
To: pgsql-docs@postgresql.org
Subject: plperl.sgml touches
Date: Thu, 8 Jul 2010 20:49:25 +0200
Message-ID: <be6f8e78d43d7ddc33e222e6f1424e47.squirrel@webmail.xs4all.nl> (raw)

Some small changes for plperl.sgml:
   - wrapped long code-lines, for pdf
   - typo

Thanks

Erik Rijkers

Attachments:

plperl.sgml.diff (application/octet-stream, 2.2K) download
--- doc/src/sgml/plperl.sgml.orig	2010-07-08 20:06:56.000000000 +0200
+++ doc/src/sgml/plperl.sgml	2010-07-08 20:37:06.000000000 +0200
@@ -173,7 +173,7 @@
    Similarly, values passed back to <productname>PostgreSQL</productname>
    must be in the external text representation format. For example, the
    <function>encode_bytea</function> function can be used to
-   to escape binary data for a return value of type <type>bytea</>.
+   escape binary data for a return value of type <type>bytea</>.
   </para>
 
   <para>
@@ -515,7 +515,8 @@
     <literal>spi_prepare</literal> accepts a query string with numbered argument placeholders ($1, $2, etc)
     and a string list of argument types:
 <programlisting>
-$plan = spi_prepare('SELECT * FROM test WHERE id &gt; $1 AND name = $2', 'INTEGER', 'TEXT');
+$plan = spi_prepare('SELECT * FROM test WHERE id &gt; $1 AND name = $2',
+                                                     'INTEGER', 'TEXT');
 </programlisting>
     Once a query plan is prepared by a call to <literal>spi_prepare</literal>, the plan can be used instead
     of the string query, either in <literal>spi_exec_prepared</literal>, where the result is the same as returned
@@ -534,7 +535,8 @@
     <para>
     <programlisting>
 CREATE OR REPLACE FUNCTION init() RETURNS VOID AS $$
-        $_SHARED{my_plan} = spi_prepare( 'SELECT (now() + $1)::date AS now', 'INTERVAL');
+        $_SHARED{my_plan} = spi_prepare( 'SELECT (now() + $1)::date AS now',
+                                         'INTERVAL');
 $$ LANGUAGE plperl;
 
 CREATE OR REPLACE FUNCTION add_time( INTERVAL ) RETURNS TEXT AS $$
@@ -571,10 +573,12 @@
 
     <para>
     <programlisting>
-CREATE TABLE hosts AS SELECT id, ('192.168.1.'||id)::inet AS address FROM generate_series(1,3) AS id;
+CREATE TABLE hosts AS SELECT id, ('192.168.1.'||id)::inet AS address
+                      FROM generate_series(1,3) AS id;
 
 CREATE OR REPLACE FUNCTION init_hosts_query() RETURNS VOID AS $$
-        $_SHARED{plan} = spi_prepare('SELECT * FROM hosts WHERE address &lt;&lt; $1', 'inet');
+        $_SHARED{plan} = spi_prepare('SELECT * FROM hosts 
+                                      WHERE address &lt;&lt; $1', 'inet');
 $$ LANGUAGE plperl;
 
 CREATE OR REPLACE FUNCTION query_hosts(inet) RETURNS SETOF hosts AS $$

view thread (2+ messages)  latest in thread

Message-ID: <be6f8e78d43d7ddc33e222e6f1424e47.squirrel@webmail.xs4all.nl>
Permalink:  ../be6f8e78d43d7ddc33e222e6f1424e47.squirrel@webmail.xs4all.nl/
Also on:    postgresql.org/message-id/be6f8e78d43d7ddc33e222e6f1424e47.squirrel@webmail.xs4all.nl

copy link · copy postgr.es · copy git am

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: er@xs4all.nl
  Subject: Re: plperl.sgml touches
  In-Reply-To: <be6f8e78d43d7ddc33e222e6f1424e47.squirrel@webmail.xs4all.nl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox