From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | stan <stanb(at)panix(dot)com> |
Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Determining the type of an obkect in plperl |
Date: | 2020-03-05 00:09:19 |
Message-ID: | CAKFQuwYmB+MbT8KzP4heuis2LavYBVeJ0G_PMampvqv2jexweA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Mar 4, 2020 at 4:21 PM stan <stanb(at)panix(dot)com> wrote:
> Probably a bit off topic, but I suspect someone on this list knows how to
> do
> this.
>
> I am in the process of writing a plperl function. In this function I need
> to compare the data in the NEW versus OLD structures. I am writing this as
> a
> generic subroutine, so I am looping through and comparing the 2 to see what
> is different. Problem is, that I need to know whether to us n != or a ne
> comparison.
>
> how can I determine what the data type of the value element is?
>
Not up to speed on Perl but you basically want everything to be done using
string equality - can't you just use "ne" everywhere and not worry about
comparing numbers using string comparison logic? Might want to disabled
warnings...
That would have to be faster than executing a type_of function on every
single column.
Then measure performance and decide whether a generic routine is performant
enough. If not you might try creating custom function dynamically using
the catalogs as input.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Rory Campbell-Lange | 2020-03-05 00:11:50 | Re: Advice request : simultaneous function/data updates on many databases |
Previous Message | David G. Johnston | 2020-03-05 00:05:21 | Re: Advice request : simultaneous function/data updates on many databases |