Re: plperl vs. bytea - Mailing list pgsql-hackers

From Tino Wildenhain
Subject Re: plperl vs. bytea
Date
Msg-id 463F0B01.2050506@wildenhain.de
Whole thread Raw
In response to Re: plperl vs. bytea  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: plperl vs. bytea  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Martijn van Oosterhout schrieb:
...> I do have one problem though: for bytea/integers/floats Perl has> appropriate internel representations. But what
aboutother user-defined> types? Say the user-defined UUID type, it should probably also passed> by a byte string, yet
howcould Perl know that. That would imply that> user-defined types need to be able to specify how they are passed to>
PLs,to *any* PL.>
 
Yes exactly. One way could be to pass the type binary and provide
a hull class for the PL/languages which then call the input/output
routines on the string boundaries of the type unless overridden by
user implementation. So default handling could be done in string
representation of the type whatever that is and for a defined set
of types every pl/language could implement special treatment like
mapping to natural types.

This handling can be done independently for every pl implementation
since it would for the most types just move the current type treatment
just a bit closer to the user code instead of doing all of it
in the call handler.

2nd problem is language interface for outside of the database scripting.
Efficient and lossless type handling there would improve some
situations - maybe a similar approach could be taken here.

Regards
Tino


pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: plperl vs. bytea
Next
From: Jim Nasby
Date:
Subject: Re: Managing the community information stream