RE: Seriously.. When are we going to get subqueries?!

[Jay Blanchard]

[snip]
Not true. Triggers are in the SQL specification. They are a legitimate 
feature with specified expected behaviour. A hack is only implementing 
function returns as default field values on timestamps, rather than 
handling all field types in a unified way and allowing them to be set to

the return value of a function by default.
[/snip]

I am aware that triggers are part of the SQL spec, I have been patiently
waiting for MySQL to add this feature. What I meant by hack is the fact
that you first have to create a function and then call it.