Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
> On Wed, 29 Jan 2003, Curt Sampson wrote:
>> ...produces rows with nulls in them.
> That's a bug in pl/pgsql I believe.
Or a bug in the domain-constraints implementation. plpgsql just
executes the input function for the datatype --- which is the same as
the input function for the underlying type. There should probably be
some mechanism to make the input function for a domain type check the
domain's constraints.
[ thinks about it... ] We added code to COPY to check domain
constraints on top of calling the type's input function, but I wonder
whether that wasn't the wrong way to go. We'll have to hack everyplace
that calls an arbitrary input function, if we insist on that approach.
regards, tom lane