Oh, got it, thanks!
чт, 17 нояб. 2022 г. в 18:52, Tom Lane :
> =?UTF-8?B?0JLQsNC00LjQvCDQodCw0LzQvtGF0LjQvQ==?=
> writes:
> > 6. But postgresql still doesn't want to use my index:
> > postgres=# explain analyze select * from zonez where '(2,2)'::point <@ p;
>
> It can't, because "polygon @> poin
=?UTF-8?B?0JLQsNC00LjQvCDQodCw0LzQvtGF0LjQvQ==?=
writes:
> 6. But postgresql still doesn't want to use my index:
> postgres=# explain analyze select * from zonez where '(2,2)'::point <@ p;
It can't, because "polygon @> point" isn't one of the operators supported
by that opclass. You could use a
Hi there,
1. I have a table that looks like this:
create table zonez (p polygon);
2. I have an index that looks like this:
create index zonez__p2 on zonez using gist(p poly_ops);
3. I inserted several records in that table, it looks like:
postgres=# select * from zonez ;
p
