Re: Problems with RAISE EXCEPTION

From: brichard(at)cafod(dot)org(dot)uk (Bruce Richardson)
To: Tulio Oliveira <mestredosmagos(at)marilia(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problems with RAISE EXCEPTION
Date: 2001-02-27 12:30:31
Message-ID: 20010227123031.B13983@usb.cafod.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Emmanuel Charpentier 2001-02-27 12:42:57 Re: Slowdown problem when writing 1.7million records
Previous Message Richard Huxton 2001-02-27 12:25:15 Re: Last x records