Re: [SQL] Help with function optimisation

2002-07-10 Thread Tom Lane
"Ian Cass" <[EMAIL PROTECTED]> writes: > I've got a function that I run as a trigger to update a summary table on > insert to the main table. As you can see below, it does a select & an INSERT > if not found, or an UPDATE if found. This currently works OK, but I'd like > to improve performance by

[SQL] Help with function optimisation

2002-07-10 Thread Ian Cass
Hi, I've got a function that I run as a trigger to update a summary table on insert to the main table. As you can see below, it does a select & an INSERT if not found, or an UPDATE if found. This currently works OK, but I'd like to improve performance by removing the SELECT & attempting an UPDATE