Re: User Defined Functions Errors

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: "A(dot) Kulikov" <a(dot)kulikov(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: User Defined Functions Errors
Date: 2005-04-18 19:07:53
Message-ID: 20050418190753.GA40910@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, Apr 18, 2005 at 10:32:26PM +0400, A. Kulikov wrote:
>
> How to I return an error from inside a user defined function?

Use RAISE. See "Errors and Messages" in the PL/pgSQL documentation.

http://www.postgresql.org/docs/8.0/interactive/plpgsql-errors-and-messages.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ying Lu 2005-04-18 20:38:49 About "Alter table... alter column.. TYPE ... "
Previous Message A. Kulikov 2005-04-18 18:32:26 User Defined Functions Errors