On Jan 2, 2012, at 16:46, Ondrej Ivanič <[email protected]> wrote:
> Hi, > > On 2 January 2012 03:26, Raymond O'Donnell <[email protected]> wrote: >>> And also - does PERFORM works with FOUND? >> >> Not sure what you mean - can you elaborate? > > No, perform (and execute) doesn't populate 'found' variable: > http://www.postgresql.org/docs/9.0/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS > > You have to use something like this: > get diagnostics rr = row_count; > > > -- > Ondrej Ivanic > ([email protected]) > > Yes, PERFORM does populate FOUND. From the documentation you just linked to.... A PERFORM statement sets FOUND true if it produces (and discards) one or more rows, false if no row is produced.
