When did this 'officially' change? "SQL-MM defines the default SRID of all geometry constructors as 0. PostGIS uses a default SRID of -1."

[Michael Downey]

Thank you!

From: Paul Ramsey <pramsey at cleverelephant.ca>
Sent: Friday, January 30, 2026 11:42 AM
To: Michael Downey <mdowney at esri.com>
Cc: postgis-users at lists.osgeo.org
Subject: Re: When did this 'officially' change? "SQL-MM defines the default SRID of all geometry constructors as 0. PostGIS uses a default SRID of -1."

That phrase is no longer in the doco, looks like it got fixed after 3.2 release.

On Fri, Jan 30, 2026 at 11:39 AM Michael Downey <mdowney at esri.com<mailto:mdowney at esri.com>> wrote:
Thanks!

From: Paul Ramsey <pramsey at cleverelephant.ca<mailto:pramsey at cleverelephant.ca>>
Sent: Friday, January 30, 2026 11:38 AM
To: Michael Downey <mdowney at esri.com<mailto:mdowney at esri.com>>
Cc: postgis-users at lists.osgeo.org<mailto:postgis-users at lists.osgeo.org>
Subject: Re: When did this 'officially' change? "SQL-MM defines the default SRID of all geometry constructors as 0. PostGIS uses a default SRID of -1."

PostGIS 2.0? 14 years ago

https://github.com/postgis/postgis/blob/master/NEWS#L1937 [github.com]<https://urldefense.com/v3/__https:/github.com/postgis/postgis/blob/master/NEWS*L1937__;Iw!!CKZwjTOV!3yYvUnUVO6JZpb3quhgJNZvGxIrrJ-8WLx1ZqGThN6rLytjb8XDhluBJKpOw_nLJxA8tmDouYe0kH_nLz0NQQA$>

Wheeps, that's a long-time doo error.

P.

On Fri, Jan 30, 2026 at 11:31 AM Michael Downey via postgis-users <postgis-users at lists.osgeo.org<mailto:postgis-users at lists.osgeo.org>> wrote:
Hello,

I see this note
“SQL-MM defines the default SRID of all geometry constructors as 0. PostGIS uses a default SRID of -1" on the PostGIS_Special_Functions_Index.html page all the way though 3.2
https://postgis.net/docs/manual-3.2/PostGIS_Special_Functions_Index.html [postgis.net]<https://urldefense.com/v3/__https:/postgis.net/docs/manual-3.2/PostGIS_Special_Functions_Index.html__;!!CKZwjTOV!3yYvUnUVO6JZpb3quhgJNZvGxIrrJ-8WLx1ZqGThN6rLytjb8XDhluBJKpOw_nLJxA8tmDouYe0kH_kQKNXXQA$>

Since then it is not there.

I have not checked this question under versions < 3.4. AI results indicate that it was 3.0 when it started. A question from a user in our community indicates 2.0.

Perhaps it started at an earlier time and culminated at 3.3?

Thanks,
Michael

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20260130/29ef6c6c/attachment.htm>