Re: Verifying a timestamp is null or in the past

Поиск
Список
Период
Сортировка
От Ondrej Ivanič
Тема Re: Verifying a timestamp is null or in the past
Дата
Msg-id CAM6mieJXSFNv6Gp+nGJ9fXTVW8UbLCBUUG9pq+W7nOL-ahpfXw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Verifying a timestamp is null or in the past  (Raymond O'Donnell <rod@iol.ie>)
Ответы Re: Verifying a timestamp is null or in the past  (David Johnston <polobo@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: handling out of memory conditions when fetching row descriptions
Следующее
От: "Hagen Finley"
Дата:
Сообщение: Re: Adding German Character Set to PostgresSQL