Hi all,<br /><br />what is the default implementation for GiST index? B-Tree or R-Tree?<br />That is, if i execute the
followingSQL command:<br /><br /> CREATE index ON table USING Gist (column)<br /><br />what is the type of the
indexthat is actually built? <br /><br />If I specify R-Tree instead, with:<br /><br /> CREATE index ON table USING
Rtree(column)<br /><br />I got this message:<br /><br /> NOTICE: substituting access method "gist" for obsolete
method"rtree" <br /><br />and when I look at the SQL code that created the index in pgAdmin, I found again <br /><br
/> CREATE index ON table USING Gist (column).<br /><br />How can I specify in SQL one of the two implementations
provided(e.g . R-Tree)? <br /><br /><br />Thank you for helping.<br /><br />Regards,<br /><span class="sg">-Elena
</span>