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/