PL/PgSQL STRICT - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject PL/PgSQL STRICT
Date
Msg-id 50D47CCB.3010201@joh.to
Whole thread Raw
Responses Re: PL/PgSQL STRICT  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: PL/PgSQL STRICT  ("Marko Tiikkaja" <pgmail@joh.to>)
List 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

pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Review of Row Level Security
Next
From: Tom Lane
Date:
Subject: Re: PL/PgSQL STRICT