Tom Lane writes: > Peter Eisentraut <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly