> Not very surprising, since "WHERE foo = bar" cannot succeed if either
> foo or bar is null.
This confirms my suspicion.
> You should not be comparing every field of the rows anyway. You should
> make sure that pwd has a primary key (which by definition must be
> non-null) and then check only the primary key field or fields in the
> rule WHERE clauses.
Well this was a futile attempt to hide the primary key pwd_id on the
base table from the end user.
Thanks,
Thiemo
--
root ist die Wurzel allen Übels