Re: Verifying a timestamp is null or in the past - Mailing list pgsql-general

From Ondrej Ivanič
Subject Re: Verifying a timestamp is null or in the past
Date
Msg-id CAM6mieJXSFNv6Gp+nGJ9fXTVW8UbLCBUUG9pq+W7nOL-ahpfXw@mail.gmail.com
Whole thread Raw
In response to Re: Verifying a timestamp is null or in the past  (Raymond O'Donnell <rod@iol.ie>)
Responses Re: Verifying a timestamp is null or in the past  (David Johnston <polobo@yahoo.com>)
List pgsql-general
Hi,

On 2 January 2012 03:26, Raymond O'Donnell <rod@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.ivanic@gmail.com)

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: handling out of memory conditions when fetching row descriptions
Next
From: "Hagen Finley"
Date:
Subject: Re: Adding German Character Set to PostgresSQL