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


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly