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

Hi,   When I write in psql: testdb=# update table1 set tableattribute='any' where table_nr=1;     if a tuple exists, I get this message testdb=# update 1     if no tuple with table_nr=1 exists, I get this message testdb=# update 0       Is there a possibility to make a difference in a pgsq

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

=?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

Re: [SQL] Re: Help!!! Trying to "SELECT" and get a tree structure back.

Hi Joe, what if you want to insert a node somewhere in the tree? You have to update all nodes, right? Markus On Friday 29 June 2001 21:06, --CELKO-- wrote: > > Albert (1,12) > /\ > /\ > Bert (2,3)Chuck (4,11) >/