桂银根
桂银根
Thanks for the reply. Yes,the postgresql version I use is 11. I have added PostgreSQL bin directory to $PATH Before installing pg_hint_plan, but I still get this error.
Yes ! Postgresq-devel package is not installed on my machine. Pg_hint_plan is now successfully installed. Thank you for your help !
Like this, ```sql SELECT a.* FROM a JOIN b ON st_contains(a.geometry, b.geometry) JOIN c ON st_contains(b.geometry, c.geometry) WHERE a.id !=b.id AND b.id != c.id ```