All Products
Search

This Product

    PolarDB:ST_ScaleY

    Document Center

    PolarDB:ST_ScaleY

    Last Updated:Mar 28, 2026

    Returns the pixel size of a raster object along the Y axis in its spatial reference system.

    Prerequisites

    The raster object must have a valid spatial reference system identifier (SRID).

    Syntax

    float8 ST_ScaleY(raster raster_obj)

    Parameters

    ParameterDescription
    raster_objThe raster object.

    Examples

    Query the pixel size along both axes for all rasters in a table:

    SELECT ST_ScaleX(rast), ST_ScaleY(rast)
FROM raster_table;

    Output:

     st_scalex | st_scaley
-----------+-----------
       1.3 |       0.3