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.000000000 +0100
> +++ cvs.build/pgsql/doc/src/sgml/plpgsql.sgml 2006-12-25 11:17:04.000000000 +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 <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter
Remember to vote!