From: Tom Lane <tgl@sss.pgh.pa.us>
To: StOo <stuart@comodo.net>
Cc: pgsql-interfaces@postgreSQL.org <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] guess what its int 64 time again.
Date: Fri, 09 Apr 1999 09:59:45 -0400
Message-ID: <29432.923666385@sss.pgh.pa.us> (raw)
In-Reply-To: <370DE458.53433659@comodo.net>
StOo <stuart@comodo.net> writes:
> Im trying to store 8byte information in char form on the database now
> so i can memcpy it back to a int64 when returning a tuple. But all my
> current attempts seem to fail beacuse i cant get the data stored
> correctly.im using PQexec to senddown a sql command string built by an
> sprintf , which is causing part of my problem as you have to display
> the data as %i %c %s etc and that where it shags up.
Huh?
As far as a user program goes, int8 acts just like any other integer
type: you pass it to and from libpq in the form of an ASCII digit
string. Perhaps you're misusing sprintf --- most platforms require
either "%lld" or "%qd" to format a long long int.
Also, you should check whether 'configure' built the int8 support
at all --- the 6.4.* version of configure is not very bright about
coping with all the various variants of 64-bit-int support on different
platforms. (6.5 is much smarter.) Does the int8 regression test pass
for you?
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, stuart@comodo.net
Subject: Re: [INTERFACES] guess what its int 64 time again.
In-Reply-To: <29432.923666385@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox