plpgsql/rule question

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: plpgsql/rule question
Date: 2005-01-12 02:13:25
Message-ID: 200501111913.25828.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-01-12 03:40:14 Re: plpgsql/rule question
Previous Message Greg Stark 2005-01-12 01:06:49 Bug in pg_dump in 7.4.6?