Find out if at least one request was true?

Question

PostgreSQL

`ST_Contains` returns bool.
Request

SELECT ST_Contains(geometry, ST_SetSRID(ST_POINT(76.8964, 64.4719), 4326)) FROM roads ;

Returns a set of strings for each road. Whether the point hit the road or not.
I don't need each. Whether I need to know the point got to at least one road. How adequate is it to do `ORDER BY ASC` and `LIMIT 1`?
Or are there better solutions?

Answer 1

bool_or() aggregate function

Answer 2

SELECT 1 FROM roads WHERE ST_Contains(geometry, ST_SetSRID(ST_POINT(76.8964, 64.4719), 4326)) LIMIT 1;

If at least one record returns, then it is included.