Search Postgresql Archives

Re: what is the date format in binary query results

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Dec 12, 2007 2:14 AM, Samantha Atkins <sjatkins@xxxxxxx> wrote:
> This brings up a second question.  How should I do byte order
> conversion for 8 byte ints?  I can't use hton ntoh routines as they
> max out at 32 bits.  Is there a better way?  Also, are floating point
> numbers guaranteed uniform?
>
> If any one knows a a clean code example of binary binding of
> parameters and binary extraction of results for all major types in C
> against lippq that would be a very useful thing to have in the
> standard docs.

We are working on a patch (not necessarily to be migrated with the
source code) to allow simplified binding of binary types to native C
types.  You can see an older version here: it has examples how to read
off a lot of the types in binary.  We should have a new patch in a day
or two that should demonstrate how to read the rest of the types in
binary.  We also handled 64 bit ints...

the patch is here
http://archives.postgresql.org/pgsql-patches/2007-12/msg00014.php

if you are patient we can provide examples for all the basic built in
types, including possibly arrays...

merlin

p.s  don't top post, but I dig Ron Paul :-)

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux