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."

--0000000000000cc3ba0649a02abb
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=AFAM Michael Downey <[email protected]> =
wrote:

> Thanks!
>
>
>
> *From:* Paul Ramsey <[email protected]>
> *Sent:* Friday, January 30, 2026 11:38 AM
> *To:* Michael Downey <[email protected]>
> *Cc:* [email protected]
> *Subject:* Re: When did this 'officially' change? "SQL-MM defines the
> default SRID of all geometry constructors as 0. PostGIS uses a default SR=
ID
> 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/maste=
r/NEWS*L1937__;Iw!!CKZwjTOV!3yYvUnUVO6JZpb3quhgJNZvGxIrrJ-8WLx1ZqGThN6rLytj=
b8XDhluBJKpOw_nLJxA8tmDouYe0kH_nLz0NQQA$>
>
>
>
> Wheeps, that's a long-time doo error.
>
>
>
> P.
>
>
>
> On Fri, Jan 30, 2026 at 11:31=E2=80=AFAM Michael Downey via postgis-users=
 <
> [email protected]> wrote:
>
> Hello,
>
>
>
> I see this note
>
> =E2=80=9CSQL-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_S=
pecial_Functions_Index.html__;!!CKZwjTOV!3yYvUnUVO6JZpb3quhgJNZvGxIrrJ-8WLx=
1ZqGThN6rLytjb8XDhluBJKpOw_nLJxA8tmDouYe0kH_kQKNXXQA$>
>
>
>
> Since then it is not there.
>
>
>
> I have not checked this question under versions < 3.4. AI results indicat=
e
> 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
>
>
>
>

--0000000000000cc3ba0649a02abb
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">That phrase is no longer in the doco, looks like it got fi=
xed after 3.2 release.</div><br><div class=3D"gmail_quote gmail_quote_conta=
iner"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, Jan 30, 2026 at 11:39=
=E2=80=AFAM Michael Downey &lt;<a href=3D"mailto:[email protected]">mdowney@=
esri.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D=
"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;bor=
der-left-color:rgb(204,204,204);padding-left:1ex"><div class=3D"msg-6370186=
408715550666">





<div lang=3D"EN-US" style=3D"overflow-wrap: break-word;">
<div class=3D"m_-6370186408715550666WordSection1">
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">Thanks!<u></u><u></u>=
</span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt"><u></u>=C2=A0<u></u><=
/span></p>
<div style=3D"border-width:1pt medium medium;border-style:solid none none;b=
order-color:rgb(225,225,225) currentcolor currentcolor;padding:3pt 0in 0in"=
>
<p class=3D"MsoNormal"><b><span style=3D"font-size:11pt;font-family:Calibri=
,sans-serif">From:</span></b><span style=3D"font-size:11pt;font-family:Cali=
bri,sans-serif"> Paul Ramsey &lt;<a href=3D"mailto:[email protected]=
a" target=3D"_blank">[email protected]</a>&gt;
<br>
<b>Sent:</b> Friday, January 30, 2026 11:38 AM<br>
<b>To:</b> Michael Downey &lt;<a href=3D"mailto:[email protected]" target=3D=
"_blank">[email protected]</a>&gt;<br>
<b>Cc:</b> <a href=3D"mailto:[email protected]" target=3D"_blan=
k">[email protected]</a><br>
<b>Subject:</b> Re: When did this &#39;officially&#39; change? &quot;SQL-MM=
 defines the default SRID of all geometry constructors as 0. PostGIS uses a=
 default SRID of -1.&quot;<u></u><u></u></span></p>
</div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
<div>
<p class=3D"MsoNormal">PostGIS 2.0? 14 years ago<u></u><u></u></p>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><a href=3D"https://urldefense.com/v3/__https:/github=
.com/postgis/postgis/blob/master/NEWS*L1937__;Iw!!CKZwjTOV!3yYvUnUVO6JZpb3q=
uhgJNZvGxIrrJ-8WLx1ZqGThN6rLytjb8XDhluBJKpOw_nLJxA8tmDouYe0kH_nLz0NQQA$" ta=
rget=3D"_blank">https://github.com/postgis/postgis/blob/master/NEWS#L1937
 [github.com]</a><u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal">Wheeps, that&#39;s a long-time doo error.<u></u><u><=
/u></p>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal">P.<u></u><u></u></p>
</div>
</div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
<div>
<div>
<p class=3D"MsoNormal">On Fri, Jan 30, 2026 at 11:31<span style=3D"font-fam=
ily:Arial,sans-serif">=E2=80=AF</span>AM Michael Downey via postgis-users &=
lt;<a href=3D"mailto:[email protected]" target=3D"_blank">postg=
[email protected]</a>&gt; wrote:<u></u><u></u></p>
</div>
<blockquote style=3D"border-width:medium medium medium 1pt;border-style:non=
e none none solid;border-color:currentcolor currentcolor currentcolor rgb(2=
04,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<div>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">Hello,</span><u></u><=
u></u></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">=C2=A0</span><u></u><=
u></u></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">I see this note
</span><u></u><u></u></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">=E2=80=9CSQL-MM defin=
es the default SRID of all geometry constructors as 0. PostGIS uses a defau=
lt SRID of -1&quot; on the PostGIS_Special_Functions_Index.html
 page all the way though 3.2</span><u></u><u></u></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt"><a href=3D"https://ur=
ldefense.com/v3/__https:/postgis.net/docs/manual-3.2/PostGIS_Special_Functi=
ons_Index.html__;!!CKZwjTOV!3yYvUnUVO6JZpb3quhgJNZvGxIrrJ-8WLx1ZqGThN6rLytj=
b8XDhluBJKpOw_nLJxA8tmDouYe0kH_kQKNXXQA$" target=3D"_blank">https://postgis=
.net/docs/manual-3.2/PostGIS_Special_Functions_Index.html
 [postgis.net]</a></span><u></u><u></u></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">=C2=A0</span><u></u><=
u></u></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">Since then it is not =
there.</span><u></u><u></u></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">=C2=A0</span><u></u><=
u></u></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">I have not checked th=
is question under versions &lt; 3.4. AI results indicate that it was 3.0 wh=
en it started. A question from a user in our community
 indicates 2.0.</span><u></u><u></u></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">=C2=A0</span><u></u><=
u></u></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">Perhaps it started at=
 an earlier time and culminated at 3.3?</span><u></u><u></u></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">=C2=A0</span><u></u><=
u></u></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">Thanks,</span><u></u>=
<u></u></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">Michael</span><u></u>=
<u></u></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">=C2=A0</span><u></u><=
u></u></p>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>

</div></blockquote></div>

--0000000000000cc3ba0649a02abb--