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 по дате отправления