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 <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to