Re: Getting a primitive numeric value from "DatumGetNumeric"? - Mailing list pgsql-general

From Demitri Muna
Subject Re: Getting a primitive numeric value from "DatumGetNumeric"?
Date
Msg-id 19E43B98-06A3-4D78-9F86-B69D12D4BAFD@demitri.com
Whole thread Raw
In response to Re: Getting a primitive numeric value from "DatumGetNumeric"?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Getting a primitive numeric value from "DatumGetNumeric"?
List pgsql-general
Hi Tom,

On Feb 20, 2018, at 10:54 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Well, the implicit coercions work in your favor in this particular case.

Ah, I wasn’t aware of implicit coercion. Yes, that solves the problem perfectly, thanks.

Out of curiosity, how does one read a numeric type from within a C extension (i.e. get a number value out of the Datum
type)?I ask as I was unable to find an example and there are a few open questions on Stack Overflow (e.g.
https://stackoverflow.com/questions/12588554/postgres-c-function-passing-returning-numerics).

Thanks,
Demitri



pgsql-general by date:

Previous
From: Ken Tanzer
Date:
Subject: Re: Given a set of daterange, finding the continuous range thatincludes a particular date
Next
From: Adrian Klaver
Date:
Subject: Re: Given a set of daterange, finding the continuous range thatincludes a particular date