Re: converting numeric to string in postgres code

On 28 May 2013 12:07, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:

> Hello
>
> 2013/5/28 Szymon Guz <mabewlun(at)gmail(dot)com>:
> > Hi,
> > while hacking on some Postgres code I've found a problem.
> >
> > I need to convert numeric to string. I've got datum with numeric inside,
> so
> > I'm getting it like:
> >
> > Numeric *numeric = DatumGetNumeric(d);
> >
> > but later I need to have string (most probably: const char *). I've
> found a
> > couple of different ways for doing that, but I'm not aware of side
> effects.
> >
> > Which function/macro should I use?
> >
>
> There is a numeric_out function, you can use it or look on their source
> code
>
> result = DatumGetCString(DirectFunctionCall1(numeric_out, d));
>

Thanks.