>> While we're at it, what about temporary functions?
...
> Whether it's worth the trouble is another question. What's the
> use-case?
I have a data-loading script that transforms data from an intermediate
form in work tables to its final resting place in production. Part of this
is a major strin
> Is the rewrite only for the literal 'X = NULL' or will it do a test
> against a value such as 'X = OLD.X' (and rewrite is OLD.X is NULL)?
>
> Is there any way to match NULLS to each other (as I am looking for a
> literal row, not using NULL as the UNKNOWN). I suppose I could put in a
> dummy valu