Jira (PDB-1210) PSQLException: Can't infer the SQL type to use for an instance of java.math.BigInteger

[Kenneth Barber (JIRA)]

Title: Message Title

Kenneth Barber commented on PDB-1210   Re: PSQLException: Can't infer the SQL type to use for an instance of java.math.BigInteger Out of interest, JSONB can consume large numbers, but since it requires coercement anyway for numeric comparison, the result is 'it works' but you'd always need to cast to numeric in anticipation of any large numbers: {{# select cast(bar::json->>'foo' as numeric) from foo where cast(bar::json->>'foo' as numeric) > 1000; numeric ---------------------- 17348547622482641976 17348547622482641976}} Add Comment   This message was sent by Atlassian JIRA (v6.4.5#64020-sha1:78acd6c) -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.