ST_SetBandIndex
上一頁  11.8. 影像圖層頻段編輯器  下一頁

名稱

ST_SetBandIndex — 更新外部資料庫頻段的外部頻段編號

概要

raster ST_SetBandIndex(raster rast, integer band, integer outdbindex, boolean force=false);

描述

更新外部資料庫頻段的外部頻段編號。這不會觸及與外部資料庫頻段相關聯的外部影像檔案。

[Note]

如果 force 設定為 true，則不會執行任何測試以確保外部影像檔案與 PostGIS 影像圖層之間的相容性（例如對齊、像素支援）。 此模式適用於外部影像檔案中頻段被移動的情況。
[Note]

在內部，此方法會將 PostGIS 影像圖層中索引 band 的頻段替換為新的頻段，而不是更新現有的路徑資訊。

可用性：2.5.0

範例

WITH foo AS (
    SELECT
        ST_AddBand(NULL::raster, '/home/pele/devel/geo/postgis-git/raster/test/regress/loader/Projected.tif', NULL::int[]) AS rast
)
SELECT
    1 AS query,
    *
FROM ST_BandMetadata(
    (SELECT rast FROM foo),
    ARRAY[1,3,2]::int[]
)
UNION ALL
SELECT
    2,
    *
FROM ST_BandMetadata(
    (
        SELECT
            ST_SetBandIndex(
                rast,
                2,
                1
            ) AS rast
        FROM foo
    ),
    ARRAY[1,3,2]::int[]
)
ORDER BY 1, 2;

 query | bandnum | pixeltype | nodatavalue | isoutdb |                                      path                                       | outdbbandnum
-------+---------+-----------+-------------+---------+---------------------------------------------------------------------------------+--------------
     1 |       1 | 8BUI      |             | t       | /home/pele/devel/geo/postgis-git/raster/test/regress/loader/Projected.tif       |            1
     1 |       2 | 8BUI      |             | t       | /home/pele/devel/geo/postgis-git/raster/test/regress/loader/Projected.tif       |            2
     1 |       3 | 8BUI      |             | t       | /home/pele/devel/geo/postgis-git/raster/test/regress/loader/Projected.tif       |            3
     2 |       1 | 8BUI      |             | t       | /home/pele/devel/geo/postgis-git/raster/test/regress/loader/Projected.tif       |            1
     2 |       2 | 8BUI      |             | t       | /home/pele/devel/geo/postgis-git/raster/test/regress/loader/Projected.tif       |            1
     2 |       3 | 8BUI      |             | t       | /home/pele/devel/geo/postgis-git/raster/test/regress/loader/Projected.tif       |            3