Cannot usу btree_gist with distance operator on Windows

85 views Asked by At

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?

0

There are 0 answers