Re: [SQL] Kind of error-handler in a pgsql function

2001-07-05 Thread DI Hasenöhrl
Thank you for your example. I understand, in order to avoid inserting *duplicate keys*, first I try to update, when it fails make an insert. But other errors may occur, is there a possibility to distinguish between errors by an error-number. Please can you tell me, where I can find system fu

Re: [SQL] Kind of error-handler in a pgsql function

2001-07-04 Thread Tom Lane
=?iso-8859-1?Q?DI_Hasen=F6hrl?= <[EMAIL PROTECTED]> writes: > I want to know the result of an insert or update, because I call these func= > tions from an Access form and the next steps of the program depend on these= > results. See the FOUND variable (if you just want to test zero or not-zero r