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: some re-formatting in  xfunc.sgml
Date: Sat, 15 May 2010 19:52:35 +0200
Message-ID: <593514e247da4b7678268ca3528a08ee.squirrel@webmail.xs4all.nl> (raw)

Attached some formatting improvements to xfunc.sgml

(1 typo; 2x wrap long code examples to make them readable in .pdf)


Erik Rijkers

Attachments:

xfunc.sgml.diff (text/x-patch, 1.6K) download --- doc/src/sgml/xfunc.sgml.orig 2010-05-14 23:00:23.000000000 +0200 +++ doc/src/sgml/xfunc.sgml 2010-05-15 01:52:52.000000000 +0200 @@ -859,7 +859,8 @@ output parameters, like this: <programlisting> -CREATE FUNCTION sum_n_product_with_tab (x int, OUT sum int, OUT product int) RETURNS SETOF record AS $$ +CREATE FUNCTION sum_n_product_with_tab (x int, OUT sum int, OUT product int) +RETURNS SETOF record AS $$ SELECT $1 + tab.y, $1 * tab.y FROM tab; $$ LANGUAGE SQL; </programlisting> @@ -957,7 +958,8 @@ done this way: <programlisting> -CREATE FUNCTION sum_n_product_with_tab (x int) RETURNS TABLE(sum int, product int) AS $$ +CREATE FUNCTION sum_n_product_with_tab (x int) +RETURNS TABLE(sum int, product int) AS $$ SELECT $1 + tab.y, $1 * tab.y FROM tab; $$ LANGUAGE SQL; </programlisting> @@ -1026,7 +1028,8 @@ SELECT 1; $$ LANGUAGE SQL; ERROR: cannot determine result data type -DETAIL: A function returning a polymorphic type must have at least one polymorphic argument. +DETAIL: A function returning a polymorphic type must have + at least one polymorphic argument. </screen> </para> @@ -2075,7 +2078,7 @@ <programlisting> PG_FUNCTION_INFO_V1(funcname); </programlisting> - must appear in the same source file. (Conventionally. it's + must appear in the same source file. (Conventionally, it's written just before the function itself.) This macro call is not needed for <literal>internal</>-language functions, since <productname>PostgreSQL</> assumes that all internal functions

view thread (2+ messages)  latest in thread

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

 ·  · 

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: some re-formatting in  xfunc.sgml
  In-Reply-To: <593514e247da4b7678268ca3528a08ee.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