[SCM] PostGIS branch master updated. 3.7.0rc3-15-gbf2ddefb6
git at osgeo.org
git at osgeo.org
Sat Nov 14 03:34:28 PST 2026
This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "PostGIS".
The branch, master has been updated
via bf2ddefb6e9c574c21d8056097684436cea49dd0 (commit)
from d6ec8333c914a8bbd9aa44d03e43beae23c052d7 (commit)
Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.
- Log -----------------------------------------------------------------
commit bf2ddefb6e9c574c21d8056097684436cea49dd0
Author: Darafei Praliaskouski <me at komzpa.net>
Date: Sat Jun 20 20:22:57 2026 +0400
Document RETURNS TABLE columns in manual
Closes #1558
Closes https://gitea.osgeo.org/postgis/postgis/pulls/419
Closes https://github.com/postgis/postgis/pull/1060
diff --git a/NEWS b/NEWS
index 26b8eb3eb..87861a5dd 100644
--- a/NEWS
+++ b/NEWS
@@ -5,6 +5,8 @@ PostGIS 3.8.0dev
- GT-811, Remove pointer addresses from error and notice messages
(Andrew Kroh)
+ - #1558, GT-419, Document RETURNS TABLE signatures with returned columns
+ (Darafei Praliaskouski)
PostGIS 3.7.0rc3
diff --git a/doc/extras_topology.xml b/doc/extras_topology.xml
index f67cb9eef..3352204d0 100644
--- a/doc/extras_topology.xml
+++ b/doc/extras_topology.xml
@@ -706,7 +706,7 @@ SELECT topology.FixCorruptTopoGeometryColumn(schema_name, table_name, feature_co
<refsynopsisdiv>
<funcsynopsis>
<funcprototype>
- <funcdef>setof record <function>Populate_Topology_Layer</function></funcdef>
+ <funcdef>table(schema_name text, table_name text, feature_column text) <function>Populate_Topology_Layer</function></funcdef>
<paramdef></paramdef>
</funcprototype>
</funcsynopsis>
@@ -1104,7 +1104,7 @@ face without edges | 1 |
<refsynopsisdiv>
<funcsynopsis>
<funcprototype>
- <funcdef>setof record <function>ValidateTopologyRelation</function></funcdef>
+ <funcdef>table(error text, layer_id int, topogeo_id bigint, element_id bigint) <function>ValidateTopologyRelation</function></funcdef>
<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef>
</funcprototype>
</funcsynopsis>
@@ -3348,7 +3348,7 @@ and is thus usable to build edge ring linking.
<refsynopsisdiv>
<funcsynopsis>
<funcprototype>
- <funcdef>setof record <function>FindVertexSegmentPairsBelowDistance</function></funcdef>
+ <funcdef>table(seg_edge bigint, segno int, vert_edge bigint, vertno int, vert_geom geometry) <function>FindVertexSegmentPairsBelowDistance</function></funcdef>
<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef>
<paramdef><type>float8 </type> <parameter>tolerance</parameter></paramdef>
</funcprototype>
diff --git a/doc/reference_raster.xml b/doc/reference_raster.xml
index b95d865e3..50c58d698 100644
--- a/doc/reference_raster.xml
+++ b/doc/reference_raster.xml
@@ -3741,12 +3741,12 @@ FROM dummy_rast;</programlisting>
<refsynopsisdiv>
<funcsynopsis>
<funcprototype>
- <funcdef>(1) record <function>ST_BandMetaData</function></funcdef>
+ <funcdef>table(pixeltype text, nodatavalue double precision, isoutdb boolean, path text, outdbbandnum integer, filesize bigint, filetimestamp bigint) <function>ST_BandMetaData</function></funcdef>
<paramdef><type>raster </type><parameter>rast</parameter></paramdef>
<paramdef choice="opt"><type>integer </type><parameter>band=1</parameter></paramdef>
</funcprototype>
<funcprototype>
- <funcdef>(2) record <function>ST_BandMetaData</function></funcdef>
+ <funcdef>table(bandnum integer, pixeltype text, nodatavalue double precision, isoutdb boolean, path text, outdbbandnum integer, filesize bigint, filetimestamp bigint) <function>ST_BandMetaData</function></funcdef>
<paramdef><type>raster </type><parameter>rast</parameter></paramdef>
<paramdef choice="opt"><type>integer[] </type><parameter>band</parameter></paramdef>
</funcprototype>
@@ -4338,7 +4338,7 @@ WHERE rid=2;</programlisting>
<refsynopsisdiv>
<funcsynopsis>
<funcprototype>
- <funcdef>setof record <function>ST_PixelAsPolygons</function></funcdef>
+ <funcdef>table(geom geometry, val double precision, x integer, y integer) <function>ST_PixelAsPolygons</function></funcdef>
<paramdef><type>raster </type> <parameter>rast</parameter></paramdef>
<paramdef choice="opt"><type>integer </type> <parameter>band=1</parameter></paramdef>
<paramdef choice="opt"><type>boolean </type> <parameter>exclude_nodata_value=TRUE</parameter></paramdef>
@@ -4466,7 +4466,7 @@ ORDER BY x, y;</programlisting>
<refsynopsisdiv>
<funcsynopsis>
<funcprototype>
- <funcdef>setof record <function>ST_PixelAsPoints</function></funcdef>
+ <funcdef>table(geom geometry, val double precision, x integer, y integer) <function>ST_PixelAsPoints</function></funcdef>
<paramdef><type>raster </type> <parameter>rast</parameter></paramdef>
<paramdef choice="opt"><type>integer </type> <parameter>band=1</parameter></paramdef>
<paramdef choice="opt"><type>boolean </type> <parameter>exclude_nodata_value=TRUE</parameter></paramdef>
@@ -4604,7 +4604,7 @@ ORDER BY y, x;</programlisting>
<refsynopsisdiv>
<funcsynopsis>
<funcprototype>
- <funcdef>setof record <function>ST_PixelAsCentroids</function></funcdef>
+ <funcdef>table(geom geometry, val double precision, x integer, y integer) <function>ST_PixelAsCentroids</function></funcdef>
<paramdef><type>raster </type> <parameter>rast</parameter></paramdef>
<paramdef choice="opt"><type>integer </type> <parameter>band=1</parameter></paramdef>
<paramdef choice="opt"><type>boolean </type> <parameter>exclude_nodata_value=TRUE</parameter></paramdef>
@@ -5902,7 +5902,7 @@ ORDER BY y;</programlisting>
<refsynopsisdiv>
<funcsynopsis>
<funcprototype>
- <funcdef>setof record <function>ST_DumpValues</function></funcdef>
+ <funcdef>table(nband integer, valarray double precision[][]) <function>ST_DumpValues</function></funcdef>
<paramdef>
<type>raster </type> <parameter>rast</parameter>
</paramdef>
@@ -5999,7 +5999,7 @@ FROM foo;</programlisting>
<refsynopsisdiv>
<funcsynopsis>
<funcprototype>
- <funcdef>setof record <function>ST_PixelOfValue</function></funcdef>
+ <funcdef>table(val double precision, x integer, y integer) <function>ST_PixelOfValue</function></funcdef>
<paramdef>
<type>raster </type> <parameter>rast</parameter>
</paramdef>
@@ -6014,7 +6014,7 @@ FROM foo;</programlisting>
</paramdef>
</funcprototype>
<funcprototype>
- <funcdef>setof record <function>ST_PixelOfValue</function></funcdef>
+ <funcdef>table(val double precision, x integer, y integer) <function>ST_PixelOfValue</function></funcdef>
<paramdef>
<type>raster </type> <parameter>rast</parameter>
</paramdef>
@@ -6026,7 +6026,7 @@ FROM foo;</programlisting>
</paramdef>
</funcprototype>
<funcprototype>
- <funcdef>setof record <function>ST_PixelOfValue</function></funcdef>
+ <funcdef>table(x integer, y integer) <function>ST_PixelOfValue</function></funcdef>
<paramdef>
<type>raster </type> <parameter>rast</parameter>
</paramdef>
@@ -6041,7 +6041,7 @@ FROM foo;</programlisting>
</paramdef>
</funcprototype>
<funcprototype>
- <funcdef>setof record <function>ST_PixelOfValue</function></funcdef>
+ <funcdef>table(x integer, y integer) <function>ST_PixelOfValue</function></funcdef>
<paramdef>
<type>raster </type> <parameter>rast</parameter>
</paramdef>
@@ -13726,7 +13726,7 @@ FROM foo;</programlisting>
<refsynopsisdiv>
<funcsynopsis>
<funcprototype>
- <funcdef>setof record <function>ST_Contour</function></funcdef>
+ <funcdef>table(geom geometry, id integer, value float8) <function>ST_Contour</function></funcdef>
<paramdef><type>raster </type><parameter>rast</parameter></paramdef>
<paramdef choice="opt"><type>integer </type><parameter>bandnumber=1</parameter></paramdef>
<paramdef choice="opt"><type>double precision </type><parameter>level_interval=100.0</parameter></paramdef>
diff --git a/doc/reference_srs.xml b/doc/reference_srs.xml
index 8e119d87e..9c7704e56 100644
--- a/doc/reference_srs.xml
+++ b/doc/reference_srs.xml
@@ -511,7 +511,7 @@ FROM data;</programlisting>
<refsynopsisdiv>
<funcsynopsis>
<funcprototype>
- <funcdef>setof record <function>postgis_srs</function></funcdef>
+ <funcdef>table(auth_name text, auth_srid text, srname text, srtext text, proj4text text, point_sw geometry, point_ne geometry) <function>postgis_srs</function></funcdef>
<paramdef><type>text </type> <parameter>auth_name</parameter></paramdef>
<paramdef><type>text </type> <parameter>auth_srid</parameter></paramdef>
</funcprototype>
@@ -560,7 +560,7 @@ point_ne | POINT(-114.08 60.01)</screen>
<refsynopsisdiv>
<funcsynopsis>
<funcprototype>
- <funcdef>setof record <function>postgis_srs_all</function></funcdef>
+ <funcdef>table(auth_name text, auth_srid text, srname text, srtext text, proj4text text, point_sw geometry, point_ne geometry) <function>postgis_srs_all</function></funcdef>
<void/>
</funcprototype>
</funcsynopsis>
@@ -615,7 +615,7 @@ point_ne | POINT(-114.08 60.01)</screen>
<refsynopsisdiv>
<funcsynopsis>
<funcprototype>
- <funcdef>setof record <function>postgis_srs_search</function></funcdef>
+ <funcdef>table(auth_name text, auth_srid text, srname text, srtext text, proj4text text, point_sw geometry, point_ne geometry) <function>postgis_srs_search</function></funcdef>
<paramdef><type>geometry </type> <parameter>bounds</parameter></paramdef>
<paramdef choice="opt"><type>text </type> <parameter>auth_name=EPSG</parameter></paramdef>
</funcprototype>
-----------------------------------------------------------------------
Summary of changes:
NEWS | 2 ++
doc/extras_topology.xml | 6 +++---
doc/reference_raster.xml | 22 +++++++++++-----------
doc/reference_srs.xml | 6 +++---
4 files changed, 19 insertions(+), 17 deletions(-)
hooks/post-receive
--
PostGIS
More information about the postgis-tickets
mailing list