Postgres Pro
Downloads
Home   >   mailing lists

pgsql: Add STRICT to PL/pgSQL SELECT INTO, so exceptions are thrown if - Mailing list pgsql-committers

From momjian@postgresql.org (Bruce Momjian)
Subject pgsql: Add STRICT to PL/pgSQL SELECT INTO, so exceptions are thrown if
Date
Msg-id 20060615180222.DCB4E9FA621@postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
Log Message:
-----------
Add STRICT to PL/pgSQL SELECT INTO, so exceptions are thrown if more or
less than one row is returned by the SELECT, for Oracle PL/SQL
compatibility.

Improve SELECT INTO documentation.

Matt Miller

Modified Files:
--------------
    pgsql/doc/src/sgml:
        plpgsql.sgml (r1.95 -> r1.96)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/plpgsql.sgml.diff?r1=1.95&r2=1.96)
    pgsql/src/pl/plpgsql/src:
        gram.y (r1.91 -> r1.92)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpgsql/src/gram.y.diff?r1=1.91&r2=1.92)
        pl_exec.c (r1.170 -> r1.171)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpgsql/src/pl_exec.c.diff?r1=1.170&r2=1.171)
        plerrcodes.h (r1.7 -> r1.8)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpgsql/src/plerrcodes.h.diff?r1=1.7&r2=1.8)
        plpgsql.h (r1.75 -> r1.76)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpgsql/src/plpgsql.h.diff?r1=1.75&r2=1.76)
        scan.l (r1.50 -> r1.51)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpgsql/src/scan.l.diff?r1=1.50&r2=1.51)

pgsql-committers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pgsql: Clarify dynamic pl/pgsql item and add URLs.
Next
From: momjian@postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Use posix_fadvise() to avoid kernel caching of WAL contents on