Thread: libpq: Char to INT

Hi there..

I want to do a query that returns an integer and then fetch the result
as an int. My query is something like that:

SELECT 1::int

Normally, I would get the result as a char and then convert it to int.
Until here, no misteries. However, 'The Programmer's Guide' shows an
example where a char pointer is converted to an int pointer, and then
it's used normally. I tried that, but the result wasn't correct..

Just to mention, I 'm used to convert char to int with strtol.

Thanks in advance.


Nelio Pereira
IFX Networks

On Thu, Nov 09, 2000 at 02:03:47PM -0200, Nelio Alves Pereira Filho wrote:
> I want to do a query that returns an integer and then fetch the result
> as an int. My query is something like that:
>
> SELECT 1::int
>
> Normally, I would get the result as a char and then convert it to int.
> Until here, no misteries. However, 'The Programmer's Guide' shows an
> example where a char pointer is converted to an int pointer, and then
> it's used normally. I tried that, but the result wasn't correct..
>
> Just to mention, I 'm used to convert char to int with strtol.

i generally do:

  int    num;

  num = atoi(PQgetvalue(query_ptr, recnum, fnum));

--
[ Jim Mercer                 jim@reptiles.org              +1 416 410-5633 ]
[          Reptilian Research -- Longer Life through Colder Blood          ]
[  Don't be fooled by cheap Finnish imitations; BSD is the One True Code.  ]

Can someone give me an idea of exactly what usogres does? I went to the
english site but I am not clear on what exactly it does.

Mark