Обсуждение: Create Produre for DROP row

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.

Languagel: plpgsql

Thanks.

On 1/11/06, Marcos <mjs_ops@gmx.net> 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.
>
> Languagel: plpgsql
>
> Thanks.
>

in 8.x.x

BEGIN

     DELETE FROM .....

EXCEPTION
       WHEN others THEN
                  ...........
END;

documentation:
http://www.postgresql.org/docs/current/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING

a list of errors:
http://www.postgresql.org/docs/current/static/errcodes-appendix.html

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

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

On Wed, Jan 11, 2006 at 03:40:22PM -0600, Guy Rouillier wrote:
> 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.

I suspect http://lnk.nu/postgresql.org/7ma.html will be of use to the
original poster, in particular FOUND.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

> BEGIN
>
>      DELETE FROM .....
>
> EXCEPTION
>        WHEN others THEN
>                   ...........
> END;
>
> documentation:
> http://www.postgresql.org/docs/current/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING
>
> a list of errors:
> http://www.postgresql.org/docs/current/static/errcodes-appendix.html
>
> --
> regards,

Thanks.

When I use the EXCEPTION and I return a value numeric or text the
Postgresql shows a error of encoding :(... Invalid Encoding UTF-8 at...

This error only occurs when a EXCEPTION treated by me it's raised.

My database is in UTF8 encoding.

What's happen?

E.g:


EXCEPTION
      WHEN others THEN RETURN 'Error';

Marcos.