[postgis-devel] Typmod Again

Olivier Courtin olivier.courtin at gmail.com
Thu Jul 23 00:06:02 PDT 2009


Hi,

> Bloody heck, you're right... the best laid plans... well, I could
> squeeze type down to 5 bits (32 possibilities) or srid down to 23 bits
> (8388608 possibilities). Any preferences? (We currently only use 4
> bits for type, so this still an improvement, and official EPSG codes
> still don't exceed 65536.)

17 differentes types are defined in current SQL/MM spec,
so 5 bits should be enough

On the other hand, could we add a bit to be able to do the difference between
planar metric geometries and geocentrics ones ?
Could be realy usefull...

--
Olivier



More information about the postgis-devel mailing list