| From: | Marko Tiikkaja <pgmail(at)joh(dot)to> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | PL/PgSQL STRICT |
| Date: | 2012-12-21 15:14:19 |
| Message-ID: | 50D47CCB.3010201@joh.to |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
Courtesy of me, Christmas comes a bit early this year. I wrote a patch
which allows you to add STRICT into PERFORM and INSERT/UPDATE/DELETE
without specifying an INTO clause. Observe:
=# create table foo(a int);
CREATE TABLE
=# create function foof() returns void as $$ begin update strict foo set
a=a+1; end $$ language plpgsql;
CREATE FUNCTION
=# select foof();
ERROR: query returned no rows
I know everyone obviously wants this, so I will be sending another
version with regression tests and documentation later. The code is a
bit ugly at places, but I'm going to work on that too.
Regards,
Marko Tiikkaja
| Attachment | Content-Type | Size |
|---|---|---|
| strict.patch | text/plain | 5.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-12-21 15:39:59 | Re: PL/PgSQL STRICT |
| Previous Message | Kevin Grittner | 2012-12-21 14:48:26 | Re: Review of Row Level Security |