ST_NotSameAlignmentReason — Returns text stating if rasters are aligned and if not aligned, a reason why.
text ST_NotSameAlignmentReason(raster rastA, raster rastB);
Returns text stating if rasters are aligned and if not aligned, a reason why.
![]()  | |
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
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)