Re: Mutating table inside trigger

On Mon, 10 Mar 2003, edprochak_at_adelphia.net wrote:

> But the question arises: Why do you want to hardcode business
> logic into the database? This should, as Daniel pointed out, be
> done at the application level, or maybe the middle level in a
> 3-tier architecture. You are making this harder by trying to do
> it in the database.

He is making it harder by putting it into a trigger. Putting all inserts into one stored procedure is a fine way to go.

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.