Re: plpgsql defensive mode - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Re: plpgsql defensive mode
Date
Msg-id 540B4A41.3080603@joh.to
Whole thread Raw
In response to Re: plpgsql defensive mode  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: plpgsql defensive mode
List pgsql-hackers
On 2014-09-06 7:50 PM, Pavel Stehule wrote:
> 2014-09-06 16:31 GMT+02:00 Marko Tiikkaja <marko@joh.to>:
>> How do you run queries which affect more than one row in this mode?
>> Because that's crucial as well.  We want something we can run 100% of our
>> code on, but with a slightly more convenient syntax than PL/PgSQL provides
>> right when coding defensively in the cases where exactly one row should be
>> affected.
>>
>
> you use a normal function. I don't expect, so it can be too often in your
> case.

Then that doesn't really solve our problem.  Switching between two 
languages on a per-function basis, when both look exactly the same but 
have very different semantics would be a nightmare.


.marko



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: plpgsql defensive mode
Next
From: Pavel Stehule
Date:
Subject: Re: plpgsql defensive mode