Why I can't force to work these queries:
select '2018-09-10 03:00:00+03'::timestamptz <-> '2018-09-10 03:00:00+03'::timestamptz
select * from T
order by time <-> '2018-09-10 03:00:00+03'::timestamptz
limit 1
Error: operator does not exist: timestamp with time zone <-> timestamp with time zone
I also tried to install pg_trgm.
PostgreSQL 12.2
btree_gist 1.5
Windows Server 2012 R2
What I did wrong?