Re: [NOOB] try tu put a number with pqexecprepare - Mailing list pgsql-general

From Daniel Verite
Subject Re: [NOOB] try tu put a number with pqexecprepare
Date
Msg-id bce3a367-b0cc-406e-8d40-2e8cdd8a0eea@mm
Whole thread Raw
In response to [NOOB] try tu put a number with pqexecprepare  (elekis <elekis@gmail.com>)
Responses Re: [NOOB] try tu put a number with pqexecprepare  (elekis <elekis@gmail.com>)
List pgsql-general
    elekis wrote:

> I put the code here
>
> http://pastebin.com/m1860cc27
>
>
> I symply try to put the number 5 for the second column, and after
that
> read the line.
>
>
> but the database, I have taht
> 83886080 in place of 5.

83886080 happens to be ntohl(5), it's probably not a coincidence :)

Since  you're using binary format for your integer parameters, you must
convert them from host byte order to network byte order with htonl()
and conversely use ntohl() for results.

 Best regards,
--
 Daniel
 PostgreSQL-powered mail user agent and storage:
http://www.manitou-mail.org

pgsql-general by date:

Previous
From: Abdul Rahman
Date:
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
Next
From: elekis
Date:
Subject: Re: [NOOB] try tu put a number with pqexecprepare