plpgsql/rule question - Mailing list pgsql-general

From Ed L.
Subject plpgsql/rule question
Date
Msg-id 200501111913.25828.pgsql@bluepolka.net
Whole thread Raw
Responses Re: plpgsql/rule question  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: plpgsql/rule question  (Michael Fuhr <mike@fuhr.org>)
List 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 by date:

Previous
From: Greg Stark
Date:
Subject: Bug in pg_dump in 7.4.6?
Next
From: Tom Lane
Date:
Subject: Re: plpgsql/rule question