Re: Create Produre for DROP row - Mailing list pgsql-general

From Guy Rouillier
Subject Re: Create Produre for DROP row
Date
Msg-id CC1CF380F4D70844B01D45982E671B239E8E33@mtxexch01.add0.masergy.com
Whole thread Raw
In response to Create Produre for DROP row  (Marcos <mjs_ops@gmx.net>)
Responses Re: Create Produre for DROP row  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-general
Marcos wrote:
> Hi,
>
> Does have possible create one procedure to delete a row that return
> TRUE if the deletion was success or FALSE if a error occur?
>
> The procedure for deletion I already create but I don't know how
> detect if the deletion was success executed.

How do you define success?  A delete can do nothing and be considered
successfully executed as long as no DB errors occur.  If all you want to
know is whether or not DB errors occurred, then Jaime supplied a
solution to that.

--
Guy Rouillier


pgsql-general by date:

Previous
From: Assad Jarrahian
Date:
Subject: getting access to geodistance (what do I need to install/enable) in an existing db install
Next
From: Michael Fuhr
Date:
Subject: Re: Different exponent in error messages