All Products
Search
Document Center

AnalyticDB:Less than operator (<)

Last Updated:Mar 30, 2026

Compares the universally unique identifiers (UUIDs) of two raster objects and returns true if the UUID of the first object is less than that of the second.

This operator compares UUIDs only—not spatial extents or pixel types. It is intended for internal database operations such as union and B-tree ordering, not for spatial comparison in application queries.

Syntax

bool Operator <(raster rast1, raster rast2)

Parameters

Parameter Description
rast1 The first raster object.
rast2 The second raster object.

Example

The following query compares the UUIDs of matched raster objects from two tables and returns true if the UUID of a.rast is less than that of b.rast.

SELECT a.rast < b.rast
FROM tbl_a a, tbl_b b
WHERE a.id = b.id