Re: Verifying a timestamp is null or in the past

On Jan 2, 2012, at 16:46, Ondrej Ivanič <ondrej(dot)ivanic(at)gmail(dot)com> wrote:

> Hi,
>
> On 2 January 2012 03:26, Raymond O'Donnell <rod(at)iol(dot)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(dot)ivanic(at)gmail(dot)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.