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 по дате отправления
От: Kevin Grittner
Дата:
От: Tom Lane
Дата:
Сообщение: Re: PL/PgSQL STRICT
FAQ