Re: Why forbid "INSERT INTO t () VALUES ();" - Mailing list pgsql-hackers

From Fabien COELHO
Subject Re: Why forbid "INSERT INTO t () VALUES ();"
Date
Msg-id alpine.DEB.2.22.394.2006251542380.2939276@pseudo
Whole thread Raw
In response to Re: Why forbid "INSERT INTO t () VALUES ();"  (Vik Fearing <vik@postgresfriends.org>)
List pgsql-hackers
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.



pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: xid wraparound danger due to INDEX_CLEANUP false
Next
From: Tom Lane
Date:
Subject: Re: More tzdb fun: POSIXRULES is being deprecated upstream