ST_Value

Returns the value of a raster cell at the specified band, column, and row position.

Syntax

float8 ST_Value(raster rast, integer band, integer colsn, integer rowsn, boolean exclude_nodata_value)

Parameter	Description
`rast`	The raster object.
`band`	The sequence number of the band. Band sequence numbers start at 0. Default value: 0.
`colsn`	The column number of the cell. Default value: 0.
`rowsn`	The row number of the cell. Default value: 0.
`exclude_nodata_value`	Specifies whether to exclude NoData values from the result. Default value: true.

SELECT st_value(rast, 1, 3, 4) FROM t_pixel WHERE id=2;
 st_value
----------
       88
(1 row)