plpgsql/rule question

Поиск
Список
Период
Сортировка
Искать
От
Ed L.
Тема
plpgsql/rule question
Дата
Msg-id
200501111913.25828.pgsql@bluepolka.net
Список
Дерево обсуждения
plpgsql/rule question "Ed L." <pgsql@bluepolka.net>
Re: plpgsql/rule question Michael Fuhr <mike@fuhr.org>
Re: plpgsql/rule question Tom Lane <tgl@sss.pgh.pa.us>
Re: plpgsql/rule question "Ed L." <pgsql@bluepolka.net>
Re: plpgsql/rule question Tom Lane <tgl@sss.pgh.pa.us>
Re: plpgsql/rule question "Ed L." <pgsql@bluepolka.net>

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 по дате отправления
От: Greg Stark
Дата:
Сообщение: Bug in pg_dump in 7.4.6?
От: Tom Lane
Дата:
Сообщение: Re: plpgsql/rule question
FAQ