Re: Aleatory exception - found cause

Поиск
Список
Период
Сортировка
От Sabin Coanda
Тема Re: Aleatory exception - found cause
Дата
Msg-id fi6ebi$26l$1@news.hub.org
обсуждение исходный текст
Ответ на Aleatory exception  ("Sabin Coanda" <sabin.coanda@deuromedia.ro>)
Список pgsql-sql
Hi,

Finally I found the cause of the problem.

I found deeper inside my calls, a function which has to return an integer 
column from a RECORD rec variable. The rec is assigned with the following 
statement:       EXECUTE 'SELECT pk AS "PK" FROM "my_table" WHERE my_where_clause' 
INTO rec.

When my_where_clause is not fulfilled, rec is initialized somehow with null. 
The exception is rised at the end where I call:       RETURN rec."PK"

Maybe someone can explain this behavior.

TIA,
Sabin 




В списке pgsql-sql по дате отправления:

Предыдущее
От: Martin Marques
Дата:
Сообщение: Re: PL argument max size, and doubt
Следующее
От: Louis-David Mitterrand
Дата:
Сообщение: Re: dynmic column names inside trigger?