| From: | momjian(at)postgresql(dot)org (Bruce Momjian) |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: Add STRICT to PL/pgSQL SELECT INTO, so exceptions are thrown if |
| Date: | 2006-06-15 18:02:22 |
| Message-ID: | 20060615180222.DCB4E9FA621@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-hackers |
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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2006-06-15 19:15:00 | pgsql: Use posix_fadvise() to avoid kernel caching of WAL contents on |
| Previous Message | Bruce Momjian | 2006-06-15 18:00:24 | Re: pgsql: Clarify dynamic pl/pgsql item and add URLs. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-06-15 19:18:05 | Re: Remove the limit on the number of entries allowed in catcaches, |
| Previous Message | Bruce Momjian | 2006-06-15 18:02:12 | Re: [PATCHES] PL/pgSQL: SELECT INTO EXACT |