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