--- On Wed, 1/2/08, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
> [ pokes at it... ] The reason is that you defined both the trigger and
> the testing function as STABLE, which means that they see a snapshot of
> the database as of the start of the calling SQL command. In the first
> case that's the UPDATE, in the second it's the COMMIT.
Thanks for the help Tom. This information is good to know.
Regards,
Richard Broersma Jr.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
