Chapman Flack <chap@anastigmatix.net> writes:
> On 04/11/2018 10:41 AM, Tom Lane wrote:
>> So maybe we need to take two steps back and talk about the semantics
>> of what you're doing.
> The mission is to implement java.sql.SQLXML, which has long been
> missing from PL/Java.
> This is the class of object your Java code can retrieve from a
> ResultSet row from a query with an XML column type. (It's also
> what can be passed to you as a function parameter, if your
> function's SQL declaration has a parameter type XML.)
OK, but if this object only lives within a single function call,
what's the problem? The underlying row must be visible to the
calling query, and that condition won't change for the duration
of the call.
Things could get interesting if you consider a Java *procedure*,
but I think you could afford to detoast-on-entry for that case.
(Wanders away wondering what Peter has done about toasted parameter
values for procedures in general ...)
regards, tom lane