|To:||Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>|
|Subject:||Re: bool_plperl transform|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
Please find the full patch attached.
>Воскресенье, 1 марта 2020, 7:57 +03:00 от Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>:
>On 2/29/20 4:55 PM, Ivan Panchenko wrote:
>> 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
>> 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.
>Andrew Dunstan https://www.2ndQuadrant.com
>PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
|Next Message||Andres Freund||2020-03-01 08:36:01||Improving connection scalability: GetSnapshotData()|
|Previous Message||Krasiyan Andreev||2020-03-01 06:32:17||Re: [PATCH] distinct aggregates within a window function WIP|