Gene wrote: > I was trying to create a rule to set a column to false whenever another > column was changed:
Don't. Use a BEFORE trigger, and instead of issuing a new UPDATE, just change the NEW record that you return. It's conceptually much simpler. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
