Name

ST_NotSameAlignmentReason — Returns text stating if rasters are aligned and if not aligned, a reason why.

Synopsis

text ST_NotSameAlignmentReason(raster rastA, raster rastB);

Description

Returns text stating if rasters are aligned and if not aligned, a reason why.

[Note]

If there are several reasons why the rasters are not aligned, only one reason (the first test to fail) will be returned.

Availability: 2.1.0

Examples

SELECT
	ST_SameAlignment(
		ST_MakeEmptyRaster(1, 1, 0, 0, 1, 1, 0, 0),
		ST_MakeEmptyRaster(1, 1, 0, 0, 1.1, 1.1, 0, 0)
	),
	ST_NotSameAlignmentReason(
		ST_MakeEmptyRaster(1, 1, 0, 0, 1, 1, 0, 0),
		ST_MakeEmptyRaster(1, 1, 0, 0, 1.1, 1.1, 0, 0)
	)
;

 st_samealignment |            st_notsamealignmentreason
------------------+-------------------------------------------------
 f                | The rasters have different scales on the X axis
(1 row)
				

See Also

Section 4.5.1, “Loading and Creating Rasters”, ST_SameAlignment