Hi all,
Having installed a fresh installation of 11.2, for some reason, the thought of making an OME function to convert a hex string into its integer8 equivalent came to mind. And so:
select hex2int('a'), hex2int('0xb'), hex2int('+0xc'), hex2int('-0xd')
┌──────────────────────┬──────────────────────┬──────────────────────┬──────────────────────┐
│col1 │col2 │col3 │col4 │
├──────────────────────┼──────────────────────┼──────────────────────┼──────────────────────┤
│ 10│ 11│ 12│ -13│
└──────────────────────┴──────────────────────┴──────────────────────┴──────────────────────┘
(1 row)
Yep, that looks good! Now for some error testing:
select hex2int('wrong')
E_US2525 'hex2int' is only supported by queries on X100 tables.
What?
And in fact whenever my code finds a condition in which it generates an error, I get the above error at the front end rather than my error text. Nothing comes into the errlog.
Can anyone shed some light on that one please.
Marty
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20210730/d7a08e03/attachment.html>