Re: passing null parameter to plpgsq functions

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: passing null parameter to plpgsq functions
Дата
Msg-id 00a701c0bc14$dc4bd920$1001a8c0@archonet.com
обсуждение исходный текст
Ответ на passing null parameter to plpgsq functions  ("Picard, Cyril" <cyril.picard@eads-dsn.com>)
Список pgsql-sql
From: "Picard, Cyril" <cyril.picard@eads-dsn.com>

> Hello
> I wrote a plpgsql function with few parameters ; when I call the function,
> some of the parameters can be null.
> In this case, all the parameters are considered as null in the function's
> body ! is it a feature ? how can I work around this ?

It's a feature in versions before 7.1 (or possibly 7.0.x) you can still get
that behaviour in 7.1 by asking for strict null handling on a specific
function.

The only remedy AFAIK is to upgrade.

- Richard Huxton



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

Предыдущее
От: "Richard Huxton"
Дата:
Сообщение: Re: Appropriate indices to create for these queries
Следующее
От: "Picard, Cyril"
Дата:
Сообщение: RE: passing null parameter to plpgsq functions