"Aguinaldo Possatto" <[EMAIL PROTECTED]> writes: > an exception is raised when this block is being executed:
> if ( ((tg_op = 'INSERT') and > (new.field is not null)) or > ((tg_op = 'DELETE') and > (old.field is not null)) ) > then > ... > end if; > the error is : > "SQL Error: ERRO: record "old" is not assigned yet" > but if the evaluation was "short-circuit" this error would not happen. The evaluation is not short-circuit, and is not going to become so. See for instance http://www.postgresql.org/docs/7.4/static/sql-expressions.html#SYNTAX-EXPRESS-EVAL The particular problem at hand here arises from different issues (specifically that plpgsql has to push down all the variable values it has at hand before the IF expression's evaluation can start) but the fact remains that SQL does not promise short-circuit evaluation. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
