ST_Raster.hasStats

Definition

The ST_Raster.hasStats function indicates whether or not the ST_Raster has images statistics calculated. It returns 1 if the statistics are present and 0 if they are not.

Syntax

Oracle

hasStats()

PostgreSQL

hasStats(raster IN ST_RASTER)

SQL Server

hasStats()

Returns

Oracle

Number

PostgreSQL

Boolean

SQL Server

Integer

Parameters

None

Example

The following query shows whether the image statistics are available or not for each raster in the table:

Oracle

SELECT t.image.raster_id, t.image.hasStats()
FROM FOO t;

T.IMAGE.RASTER_ID T.IMAGE.HASSTATS()
---------------   ------------------
              2                1
              3                0
             23                0
             24                0
             42                0
             43                0

PostgreSQL

SELECT raster_id(image), hasStats(image)
FROM foo;


RASTER_ID(IMAGE) HASSTATS(IMAGE)
---------------  ---------------
              2                1
              3                0
             23                0
             24                0
             42                0
             43                0

SQL Server

SELECT image.raster_id, image.hasStats()
FROM foo;

IMAGE.RASTER_ID IMAGE.HASSTATS()
--------------- ----------------
              2                1
              3                0
             23                0
             24                0
             42                0
             43                0