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