Re: [HACKERS] Re: SQL compliance

Peter Eisentraut <peter_e@gmx.net> writes:
> * Things such as SELECT MAX(ALL x) FROM y; don't work.  [6.5]
> {This seems to be an easy grammar fix.}

Yes, and since ALL is already a reserved word, it wouldn't break
anything to accept it.  I'll try to take care of that today.
None of the other stuff is quite as easy to fix :-(


> * INSERT INTO table DEFAULT VALUES  [13.8]
> {Looks like a grammar fix as well.}

Huh?  We do have DEFAULT VALUES --- what is wrong exactly?

What we don't seem to have is full <table value constructor> per 7.2;
we only allow VALUES ... in INSERT, whereas SQL allows it in other
constructs where a sub-SELECT would be legal, and we don't accept
multiple rows in VALUES.  For example, you should be able to write
INSERT INTO t VALUES (1,2,3), (4,5,6), (7,8,9), ...

but we don't accept that now.  The spec also shows several examples like
     CONSTRAINT DOMAIN_CONSTRAINTS_CHECK_DEFERRABLE       CHECK ( ( IS_DEFERRABLE, INITIALLY_DEFERRED ) IN
( VALUES ( 'NO',  'NO' ),                        ( 'YES', 'NO' ),                        ( 'YES', 'YES' ) ) )
 


Thanks for digging through the spec ... I bet that was tedious ...
        regards, tom lane