Re: Why forbid "INSERT INTO t () VALUES ();"

Bonjour Vik,

>>> It's forbidden because the SQL standard forbids it.
>>
>> Ok, that is definitely a reason. I'm not sure it is a good reason, though.

> It's a very good reason. It might not be good *enough*, but it is a
> good reason.

Ok for good, although paradoxically not "good enough":-)

>> Why would the standard forbid it? From the language design point of
>> view[...]
>
> Don't go there. There is nothing but pain there.

Hmmm. I like to understand. Basically it is my job.

Otherwise, yes and no. Postgres could decide (has sometimes decided) to
extend the syntax or semantics wrt the standard if it makes sense, so that
when a syntax is allowed by the standard it does what the standard says,
which I would call positive compliance and I would support that, but keep
some freedom elsewhere.

--
Fabien.