COMMAND_OK for PL/pgSQL? - Mailing list pgsql-general

From Ben
Subject COMMAND_OK for PL/pgSQL?
Date
Msg-id Pine.LNX.4.44.0210260904020.16949-100000@localhost.localdomain
Whole thread Raw
Responses Re: COMMAND_OK for PL/pgSQL?  (Darko Prenosil <darko.prenosil@finteh.hr>)
List pgsql-general
I'm just getting into writting stored procs with PL/pgSQL, and I'm having
a hard time finding a way to check the status of my commands. For
instance, I see that after an insert, I can get the RESULT_OID - but I'm
not sure this is a good way to check if the insert happened correctly and
didn't violate any constraints. If it is, how do I check that the oid
returned is valid?



pgsql-general by date:

Previous
From: Hervé Piedvache
Date:
Subject: Re: question about seq scan and index scan
Next
From: Ben
Date:
Subject: user-friendly search strings