Re: plpgsql defensive mode

Поиск
Список
Период
Сортировка
От Joel Jacobson
Тема Re: plpgsql defensive mode
Дата
Msg-id -84707453404872238@iso-8859-1msgid
обсуждение исходный текст
Ответ на Re: plpgsql defensive mode  (Marko Tiikkaja <marko@joh.to>)
Список pgsql-hackers
> On 6 sep 2014, at 16:32, Marko Tiikkaja <marko@joh.to> wrote:
>
> How do you run queries which affect more than one row in this mode? Because that's crucial as well.  We want
somethingwe can run 100% of our code on, but with a slightly more convenient syntax than PL/PgSQL provides right when
codingdefensively in the cases where exactly one row should be affected. 

If we would have ORDER BY also for UPDATE/DELETE then one could just
order by something arbitrary to express multiple or zero rows are OK,
even if not being interested in the order.

>
>
> .marko



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Allowing implicit 'text' -> xml|json|jsonb
Следующее
От: Jan Wieck
Дата:
Сообщение: Re: Improving PL/PgSQL