Horton
Menu

Re: PL/PgSQL STRICT

Marko Tiikkaja <pgmail@joh.to>

View thread
From: Marko Tiikkaja <pgmail@joh.to>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2012-12-21T16:32:23Z
Lists: pgsql-hackers 
On 12/21/12 5:22 PM, Tom Lane wrote:
> Marko Tiikkaja <pgmail@joh.to> writes:
>> Another idea would be to force the STRICT to be immediately after
>> INSERT, UPDATE or DELETE.
>
> What about before it, ie
>
> 	STRICT UPDATE ...
>
> This should dodge the problem of possible conflict with table names,
> and it seems to me to read more naturally too.

Yeah, putting STRICT after the command wouldn't work for UPDATE.

I like this one best so far, so I'm going with this syntax for the next 
version of the patch.



Regards,
Marko Tiikkaja