Re: inconsistent composite type null handling in plpgsql out variable - Mailing list pgsql-bugs

From Tom Lane
Subject Re: inconsistent composite type null handling in plpgsql out variable
Date
Msg-id 10328.1251477397@sss.pgh.pa.us
Whole thread Raw
In response to inconsistent composite type null handling in plpgsql out variable  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-bugs
Merlin Moncure <mmoncure@gmail.com> writes:
> Today I ran into a problem relating to $subject.  plpgsql's handling
> of 'null' composite types is not consistent with what you get in sql:

Hm.  It looks like plpgsql treats composite arguments as being "row"
instead of "record" variables, which has some possible efficiency
benefits but there's no way to represent the whole row being null, as
opposed to existing but having all null fields.  Not sure how painful
it'd be to change to "record" representation.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Merlin Moncure
Date:
Subject: inconsistent composite type null handling in plpgsql out variable
Next
From: Robert Haas
Date:
Subject: Re: BUG #5013: Error in psqlodbc configuration