Re: [GENERAL] Problems with RAISE EXCEPTION

2001-02-27 Thread Bruce Richardson
On Tue, Feb 27, 2001 at 08:40:27AM -0300, Tulio Oliveira wrote: > But the RAISE EXCEPTION don't accept variables, only a CONTANT STRING. > > Nor strigs concatenation are supported You can add variables to the string, like this: RAISE EXCEPTION "Record % has same name as record %", new.

[GENERAL] Problems with RAISE EXCEPTION

2001-02-27 Thread Tulio Oliveira
Hi, My triggers performs a lot of verifications over the data before insert or update. So I need make all checks, and at the end, RAISE EXCEPTION msgsErrors; and the variable msgsErrors containing all Error Messages reported by hole trigger. But the RAISE EXCEPTION don't accept variables, on