"Behrang Saeedzadeh" <behrangsa@xxxxxxxxx> writes: > Actually I read in a blog that this works in PostgreSQL (the author > expected this) and not in MySQL. But to me, the way MySQL is handling > this looks more reasonable. MySQL's way of doing things is seldom reasonable. In the example given, they are clearly inventing a default value out of thin air. There is *no* support for that in the SQL spec. regards, tom lane
