On Jan 2, 2012, at 16:46, Ondrej Ivanič <ondrej.iva...@gmail.com> wrote:
> Hi, > > On 2 January 2012 03:26, Raymond O'Donnell <r...@iol.ie> 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 > (ondrej.iva...@gmail.com) > > 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.
