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