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