Raise exception from regular SQL?

From: "Steve - DND" <postgres(at)digitalnothing(dot)com>
To: "postgres-general" <pgsql-general(at)postgresql(dot)org>
Subject: Raise exception from regular SQL?
Date: 2005-04-21 08:41:24
Message-ID: LDEHKBBOEMIJKHKBOFNFEEPJNFAA.postgres@digitalnothing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to add some clarity to the rules I have on my tables. When a rule
is broken, I want to give a more informative message, so that the client
side can deal with it in a nicer manner. Right now I'm creating plpgsql
functions, and raising an exception in there with the customized text.

Is there a way to raise exceptions with regular SQL so that I don't have to
go to plpgsql?

Thanks,
Steve

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2005-04-21 08:58:40 (Fwd) Re: windows, cant find ostgresql.conf
Previous Message Thomas Hallgren 2005-04-21 08:32:37 Functions returning RECORD