women_lover_best wrote:

>Hi,
>when we use generator,why do we use syntax like..
>if new.id=null
>new.id=gen(x,1)..why not just use 2nd line?
>
>

This allows the user to supply their own value for ID without having the
trigger overwrite it. The triggers only supplies a value when the value
is null.