[postgis-devel] Typmod: Making my Life Harder

[Stephen Frost]

* Paul Ramsey (pramsey at opengeo.org) wrote:
> However, for geography this gets further pointless as the initial
> implementation is only going to accept 4326 as an SRID. And even when
> it *does* accept alternates most people will just want to use 4326.
> Also, one of the user targets for geography is geo-newbies, the folks
> coming in with lonlat data and a dream. They shouldn't need to know
> the "magic number", they should just need to be told "use geography,
> go away".

I'm not against having a default of 4326...

> CREATE TABLE foo (g geography(POINT));
> 
> So, should SRID be first? last? I'm actually thinking it could be
> either, because I can test the arguments and if the argument is
> numeric it is the srid and if it is letters that's the type. If we
> want a fixed ordering, then I would now go for geography(type, srid).
> I think for geometry, type *and* srid restrictions will be common, but
> for geography, type-only restrictions will be the more frequent case.

I think we should have a fixed ordering.  I dislike ambiguity or
inconsistancy in my DDL. :)

	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/20090803/24974502/attachment.sig>