Re: [PATCHES] Micro doc patch (plpgsql)
On December 26, 5:19 am David Fetter [EMAIL PROTECTED] wrote: It doesn't need the semicolon. PL/PgSQL's BEGIN is different from SQL's. :) Exactly. Note that my patch _removes_ the semicolon. If you put it in a plpgsql function definition as in the example from the docs you get a syntax error. -BEGIN; +BEGIN Joachim ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [PATCHES] Micro doc patch (plpgsql)
On Tue, Dec 26, 2006 at 01:10:03PM +0100, Joachim Wieland wrote: On December 26, 5:19 am David Fetter [EMAIL PROTECTED] wrote: It doesn't need the semicolon. PL/PgSQL's BEGIN is different from SQL's. :) Exactly. Note that my patch _removes_ the semicolon. If you put it in a plpgsql function definition as in the example from the docs you get a syntax error. Oops. Sorry about that :) Cheers, D -BEGIN; +BEGIN Joachim -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [PATCHES] Micro doc patch (plpgsql)
Joachim Wieland [EMAIL PROTECTED] writes: attached is a micro doc patch. BEGIN in plpgsql is without semicolon. Applied, thanks. regards, tom lane ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
[PATCHES] Micro doc patch (plpgsql)
Hi, attached is a micro doc patch. BEGIN in plpgsql is without semicolon. Joachim diff -ur cvs/pgsql/doc/src/sgml/plpgsql.sgml cvs.build/pgsql/doc/src/sgml/plpgsql.sgml --- cvs/pgsql/doc/src/sgml/plpgsql.sgml 2006-11-01 05:09:40.0 +0100 +++ cvs.build/pgsql/doc/src/sgml/plpgsql.sgml 2006-12-25 11:17:04.0 +0100 @@ -1243,7 +1243,7 @@ to catch the error, for example: programlisting -BEGIN; +BEGIN SELECT * INTO STRICT myrec FROM emp WHERE empname = myname; EXCEPTION WHEN NO_DATA_FOUND THEN ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [PATCHES] Micro doc patch (plpgsql)
On Tue, Dec 26, 2006 at 01:36:07AM +0100, Joachim Wieland wrote: Hi, attached is a micro doc patch. BEGIN in plpgsql is without semicolon. It doesn't need the semicolon. PL/PgSQL's BEGIN is different from SQL's. :) Cheers, D Joachim diff -ur cvs/pgsql/doc/src/sgml/plpgsql.sgml cvs.build/pgsql/doc/src/sgml/plpgsql.sgml --- cvs/pgsql/doc/src/sgml/plpgsql.sgml 2006-11-01 05:09:40.0 +0100 +++ cvs.build/pgsql/doc/src/sgml/plpgsql.sgml 2006-12-25 11:17:04.0 +0100 @@ -1243,7 +1243,7 @@ to catch the error, for example: programlisting -BEGIN; +BEGIN SELECT * INTO STRICT myrec FROM emp WHERE empname = myname; EXCEPTION WHEN NO_DATA_FOUND THEN ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! ---(end of broadcast)--- TIP 6: explain analyze is your friend
[PATCHES] Micro-doc patch for CREATE FUNCTION
It is not obvious that a function should be declared RETURNS VOID if it is not supposed to return a value. There's also a user-comment on the 8.1 doc-page. Joachim Index: create_function.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/create_function.sgml,v retrieving revision 1.68 diff -c -r1.68 create_function.sgml *** create_function.sgml 16 Sep 2006 00:30:17 - 1.68 --- create_function.sgml 3 Nov 2006 03:51:37 - *** *** 152,158 may be a base, composite, or domain type, or may reference the type of a table column. Depending on the implementation language it may also be allowed !to specify quotepseudotypes/ such as typecstring/. /para para When there are literalOUT/ or literalINOUT/ parameters, --- 152,160 may be a base, composite, or domain type, or may reference the type of a table column. Depending on the implementation language it may also be allowed !to specify quotepseudotypes/ such as typecstring/. If the !function is not supposed to return a value, specify literalVOID/ as !return type. /para para When there are literalOUT/ or literalINOUT/ parameters, ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [PATCHES] Micro-doc patch for CREATE FUNCTION
Joachim Wieland [EMAIL PROTECTED] writes: It is not obvious that a function should be declared RETURNS VOID if it is not supposed to return a value. Done, thanks. regards, tom lane ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[PATCHES] Micro doc patch
Add missing quotes. Index: docguide.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml/docguide.sgml,v retrieving revision 1.55 diff -u -r1.55 docguide.sgml --- docguide.sgml 9 Apr 2005 03:52:43 - 1.55 +++ docguide.sgml 13 May 2005 15:46:53 - @@ -417,7 +417,7 @@ filename/usr/local/share/sgml/catalog/filename can also be made: programlisting -CATALOG docbook-dsssl-1.replaceablexx//catalog +CATALOG docbook-dsssl-1.replaceablexx//catalog /programlisting Because stylesheets change rather often, and it's sometimes beneficial to try out alternative versions, Regards, Dave ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [PATCHES] Micro doc patch
Dave Page dpage@vale-housing.co.uk writes: Add missing quotes. Done, thanks. regards, tom lane ---(end of broadcast)--- TIP 8: explain analyze is your friend