Sorry, Please find the full patch attached. Ivan >Воскресенье, 1 марта 2020, 7:57 +03:00 от Andrew Dunstan ><andrew.duns...@2ndquadrant.com>: > > >On 2/29/20 4:55 PM, Ivan Panchenko wrote: >> Hi, >> While using PL/Perl I have found that it obtains boolean arguments >> from Postgres as ‘t’ and ‘f’, which is extremely inconvenient because >> ‘f’ is not false from the perl viewpoint. >> So the problem is how to convert the SQL booleans into Perl style. >> >> There are 3 ways to do this: >> >> 1. make plperl automatically convert bools into something acceptable >> for perl. This looks simple, but probably is not acceptable as it >> breaks compatibility. >> 2. try to make some trick like it is done with arrays, i.e. convert >> bools into special Perl objects which look like ‘t’ and ‘f’ when >> treated as text, but are true and false for boolean operations. I >> am not sure that it is possible and reliable. >> 3. make a transform which transforms bool, like it is done with >> jsonb. This does not break compatibility and is rather >> straightforward. >> >> So I propose to take the third way and make such transform. This is >> very simple, a patch is attached. >> Also this patch improves the plperl documentation page, which now has >> nothing said about the transforms. >> >> > >Patch appears to be missing all the new files. > > >cheers > > >andrew > > > >-- >Andrew Dunstan https://www.2ndQuadrant.com >PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services > -- Иван Панченко
bool_plperl_transform_v2.patch
Description: Binary data
