Null function parameters

Поиск
Список
Период
Сортировка
От Graham Vickrage
Тема Null function parameters
Дата
Msg-id NDBBJABDILOPAOOMFJHOOEAKCEAA.graham@digitalplanit.com
обсуждение исходный текст
Ответы Re: Null function parameters  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Hi All,

I am trying to create a function that takes an int as its param and insert
the value into a table. The problem occurs when the value passed is NULL,
the error message returned is
- Execute failed ERROR: ExecAppend: Fail to add null value in not null
attribute type

However my understanding was that if the default value is SQL NULL then any
values passed into the function that are null would be treated as 'NULL'.

This doesn't seem to be the case. Chances are I am overlooking something,
could any one point me in the right direction?

Cheers

Graham




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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Continuous inserts...
Следующее
От: "Brian C. Doyle"
Дата:
Сообщение: Re: Time Help