> > Is there any way to treat it like an inline function so that I could write > > something like the following (highly simplified): > > I think 7.4 will inline simple SQL functions. Your CASE looks like a good > candidate. > > > select case when A=1 then 1 when B=1 then 2 else null end > > as mailtype, memname from master > > where mailtype is not null;
I think it may inline it as an optimization step, I don't know of any way to shortcut how to write it. (I'm running 7.4.1.) -- Mike Nolan ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
