Обсуждение: Problems with RAISE EXCEPTION

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, only a CONTANT STRING.

Nor strigs concatenation are supported ........


I'm make any mistake ?
Exist any way to do that ?



Regards,

Tulio Oliveira

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.name,
other.name;

--
Bruce