4 ms·
There can be only one because it exists solely to be the "last updated" field. There's no point in having more than one. In MySQL, it simply only updates the fi
by gxti 16y ago
There can be only one because it exists solely to be the "last updated" field. There's no point in having more than one. In MySQL, it simply only updates the first -- so you get a sometimes magic field.
- JoachimSchipper 16y agoI would think it useful to have 'created' and 'updated' fields, for instance. And silently updating only the first...
- randallsquared 16y agoBut you can have this: the "created" field is a datetime field, and the "updated" field would be "timestamp". This is far less problematic, in my opinion, than things like requiring a table with exactly one row to do simple selects, or pretending the empty string and null are the same (both of these behaviors are Oracle, by the way, not postgresql).