Tom Lane writes:
> Peter Eisentraut <peter_e@gmx.net> writes:
> >> What's standard about it?
>
> > ISO/IEC 9075-2:1999 clause 19.1 general rule 1 c) to be exact. ;-)
>
> Hmm. Looks like we need a wholesale revision of command tags, indeed.
> At least if we want to consider command tags to be the data that
> satisfies this spec requirement.
We would need to do:
ALTER -> ALTER <type of object>
DROP -> DROP <type of object>
CREATE -> CREATE <type of object>
Those look reasonable, and we already do that in some cases.
CLOSE -> CLOSE CURSOR
DECLARE -> DECLARE CURSOR
No opinion here.
COMMIT -> COMMIT WORK
ROLLBACK -> ROLLBACK WORK
Doesn't matter to me.
DELETE -> DELETE WHERE
UPDATE -> UPDATE WHERE
I'd prefer not to do those.
SET CONSTRAINTS -> SET CONSTRAINT [sic]
SET VARIABLE -> SET TIME ZONE
SET VARIABLE -> SET TRANSACTION
SET VARIABLE -> SET SESSION AUTHORIZATION
The first one looks like a mistake. The other ones we could work on.
It also seems to me that CREATE TABLE AS should not print "SELECT". I
thought Fernando Nasser had fixed that. Maybe I'm not completely up to
date in my sources.
--
Peter Eisentraut peter_e@gmx.net
