Jeff Davis <jdavis-pgsql@empires.org> writes:
> So, it surprises me that IGNORE is part of the spec, if it is.
It is not. It's listed as a keyword reserved for future use, but no
syntax or semantics are assigned to it. (While the SQL99 authors may
have had some specific future plan in mind, I see no particular reason
to assume that whatever they might've had in mind matches what MySQL is
doing with the keyword...)
regards, tom lane