Re: PL/pgSQL 2 - Mailing list pgsql-hackers

From Joel Jacobson
Subject Re: PL/pgSQL 2
Date
Msg-id CAASwCXfG8Jc7r7sD4r-G_7juz0Xw6veMEWYtPUYoBgvYudB7rA@mail.gmail.com
Whole thread Raw
In response to Re: PL/pgSQL 2  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
On Tue, Sep 2, 2014 at 10:16 PM, Andres Freund <andres@2ndquadrant.com> wrote:
> On 2014-09-02 19:06:02 +0200, Joel Jacobson wrote:
>> But what do you think about,
>> STRICT UPDATE ...?
>
> I quite dislike it. An UPDATE isn't less 'strict' (whatever that means)
> if updates more than one row. There's some sense in the way it's used
> for INTO because it's referring to the INTO. And it's much more obvious
> what it could mean there.

For those who are familiar with the "INTO STRICT" syntax for SELECT,
I think they will also understand the meaning with UPDATE,
and maybe it could also be considered a plus not having to invent new keywords,
if we can use the ones we already have for other commands.



pgsql-hackers by date:

Previous
From: David Johnston
Date:
Subject: Re: PL/pgSQL 2
Next
From: Jan Wieck
Date:
Subject: Re: PL/pgSQL 2