Re: libpq: Char to INT - Mailing list pgsql-general

From Jim Mercer
Subject Re: libpq: Char to INT
Date
Msg-id 20001109112428.P16128@reptiles.org
Whole thread Raw
In response to libpq: Char to INT  (Nelio Alves Pereira Filho <nelio@ifx.com.br>)
List pgsql-general
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.  ]

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: need an information on PostgreSQL
Next
From: Peter Eisentraut
Date:
Subject: Re: need an information on PostgreSQL