Tom Hart wrote: > Specifically I'm looking at these two lines > > isactive and (mb_mail_cd=0 or mb_mail_cd=1) as ismail, > ismail and (mb_stat_cd=0 or mb_stat_cd=2) as ispromomail, > > which appear to use other fields it's preparing to insert as variables > in the determination of the values of other fields (I told you I > couldn't figure out how to explain it).
I can't tell more without the exact table definitions, but this should work just fine. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
