plpgsql/rule question

Поиск
Список
Период
Сортировка
От Ed L.
Тема plpgsql/rule question
Дата
Msg-id 200501111913.25828.pgsql@bluepolka.net
обсуждение исходный текст
Ответы Re: plpgsql/rule question
Re: plpgsql/rule question
Список pgsql-general
Is it possible to tell if a column in a NEW record in a plpgsql function was
explicitly specified as NULL or simply left out altogether?

For example, if I have the following table:

    create table foo(id serial, msg varchar)

Is it possible to distinguish within plpgsql between these two queries?

    insert into foo (msg) values ('Hello')
    insert into foo (id, msg) values (NULL, 'Hello')

TIA.

Ed


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