Florian Pflug <fgp@phlo.org> writes:
> On Jan14, 2014, at 01:20 , Jim Nasby <jim@nasby.net> wrote:
>> And if we've always had it, why on earth didn't we make STRICT the default
>> behavior?
> Dunno, but AFAIK pl/pgsql mimics Oracle's PL/SQL, at least in some aspects,
> so maybe this is one of the areas where we just do what oracle does.
STRICT is a relatively recent addition (8.2, looks like). One of the
reasons it got in was that the author didn't have any grandiose ideas
about making it the new default. I think this patch would have a lot
better chance if it was just adding another keyword as an alternative
to STRICT, and not hoping to impose the author's opinions on the rest
of the world. Whatever your opinion of the default behavior, the
fact that it's been that way for upwards of fifteen years without any
mass protests should give you pause about changing it.
regards, tom lane