Re: Verifying a timestamp is null or in the past

From: Ondrej Ivanič <ondrej(dot)ivanic(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Verifying a timestamp is null or in the past
Date: 2012-01-02 21:46:56
Message-ID: CAM6mieJXSFNv6Gp+nGJ9fXTVW8UbLCBUUG9pq+W7nOL-ahpfXw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hagen Finley 2012-01-02 21:47:13 Re: Adding German Character Set to PostgresSQL
Previous Message Tom Lane 2012-01-02 21:26:36 Re: handling out of memory conditions when fetching row descriptions