[postgis-devel] Typmod Again

Stephen Frost sfrost at snowman.net
Wed Jul 22 17:43:10 PDT 2009


* Paul Ramsey (pramsey at cleverelephant.ca) wrote:
> 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.)

To be honest, my original thought was to go with around 2^20, and claim
that SRIDs need to be less than 1M.  I was expecting to have to track
dimensions at the time, but still, I like the general idea of having a
simple limit like 1M on SRIDs.  That gives us some room to grow, if we
end up needing to track more types, or dimensions separately, or we can
increase the SRID range if we find out that it's necessary.

Those are my 2c, other comments welcome..

	Thanks,

		Stephen
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 197 bytes
Desc: Digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20090722/578c83ac/attachment.sig>


More information about the postgis-devel mailing list