Re: Determining the type of an obkect in plperl

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: stan <stanb(at)panix(dot)com>
Cc: Ravi Krishna <srkrishna(at)gmx(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Determining the type of an obkect in plperl
Date: 2020-03-05 11:43:47
Message-ID: 4FFE61D4-994C-436C-8624-102D121C4D0C@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Mar 5, 2020, at 4:22 AM, stan <stanb(at)panix(dot)com> wrote:
>
> On Thu, Mar 05, 2020 at 12:27:12AM +0000, Ravi Krishna wrote:
>>
>>>
>>> how can I determine what the data type of the value element is?
>>>
>> perl has a ref function which can tell what type of object.
>>
>> https://perldoc.perl.org/functions/ref.html
>>>
>>
>>
>> --
>> This email has been checked for viruses by Avast antivirus software.
>> https://www.avast.com/antivirus
>>
> Even checking gisnt teh _TD structure does not return a value:
>
> foreach my $key (sort keys %{$_TD->{old}}) {
> my $ref1 = ref $_TD->{old}->{$key};
> my $ref2 = ref $_TD->{new}->{$key};
> elog(NOTICE, "ref1 = $ref1 ref2 = $ref2" );
> .
> .
>

I’m not a Perl guy but I don’t think you need to sort the keys. You don’t care what order the comparisons are done, do you?
If it’s just “is different” your looking for why can’t you rely on Perl’s type coercing (toString()) on operands of ne? You won’t have different types under the same key.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2020-03-05 12:07:13 Re: Real application clustering in postgres.
Previous Message stan 2020-03-05 11:21:49 Re: Determining the type of an obkect in plperl