PL/PgSQL STRICT
От
Marko Tiikkaja
Тема
PL/PgSQL STRICT
Дата
Msg-id
50D47CCB.3010201@joh.to
Список
Дерево обсуждения
Re: PL/PgSQL STRICT "Marko Tiikkaja" <marko@joh.to>
Re: PL/PgSQL STRICT Tom Lane <tgl@sss.pgh.pa.us>
Re: PL/PgSQL STRICT Josh Berkus <josh@agliodbs.com>
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
В списке pgsql-hackers по дате отправления