fixed or dynamic row sizes with a field with a type of "point"...?

2006-06-11 Thread Andras Pal
Hi, we have a table with many (~0.5 billion) records and a geometry field which was defined as a simple "point". The `show table status` shows that the row format is dynamic, however, a simple point in the GIS representation has a fixed format (see: WKB: 21 bytes: 1 for MSB/LSB, 4 for type and 2x8

fetch floats/doubles in native binary representation

2006-05-25 Thread Andras Pal
Hi, I've a large table with lots of floats (or doubles) that i want to query using C API. By default, in C, the rows are returned as a type of char **, therefore floating numbers are returned as ascii strings. Is it possible to fetch somehow directly these numbers in their original binary represe