Re: [GENERAL] Temporary views

2004-02-11 Thread Arthur Ward
>> 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

Re: [GENERAL] SET within a function?

2003-10-14 Thread Arthur Ward
> 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