libpq: Char to INT

Started by Nelio Alves Pereira Filhoover 25 years ago4 messagesgeneral

Jump to latest

Nelio Alves Pereira Filho

nelio@ifx.com.br

over 25 years ago

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

Jim Mercer

jim@reptiles.org

over 25 years ago

In reply to: Nelio Alves Pereira Filho (#1)

Re: libpq: Char to INT

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. ]