Re: what is the date format in binary query results

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: what is the date format in binary query results
Дата
Msg-id b42b73150712121808t165c69c9n6882844d07aa56d6@mail.gmail.com
обсуждение исходный текст
Ответ на Re: what is the date format in binary query results  (Samantha Atkins <sjatkins@mac.com>)
Ответы Re: what is the date format in binary query results  (Andrew Chernow <ac@esilo.com>)
Re: what is the date format in binary query results  (Andrew Chernow <andrew@esilo.com>)
Список pgsql-general
On Dec 12, 2007 2:14 AM, Samantha Atkins <sjatkins@mac.com> 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 :-)

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Slow PITR restore
Следующее
От: Andrew Chernow
Дата:
Сообщение: Re: what is the date format in binary query results