Re: Problems with RAISE EXCEPTION - Mailing list pgsql-general

From brichard@cafod.org.uk (Bruce Richardson)
Subject Re: Problems with RAISE EXCEPTION
Date
Msg-id 20010227123031.B13983@usb.cafod.org.uk
Whole thread Raw
In response to Problems with RAISE EXCEPTION  (Tulio Oliveira <mestredosmagos@marilia.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: martin.chantler@convergys.com
Date:
Subject: Re: Migrate from MS SQL 6.5 to postgres??
Next
From: "Richard Huxton"
Date:
Subject: Re: Last x records