Re: index find method? - Mailing list pgsql-sql

From Rafael Domiciano
Subject Re: index find method?
Date
Msg-id 3a0028490806180903n7fe08849m26ba4a78ee5f6edf@mail.gmail.com
Whole thread Raw
In response to index find method?  ("Jorge Medina" <jorge@bsdchile.cl>)
List pgsql-sql
Hello,<br /><br />The Default method is btree, that is the commonly method used in the indexes.<br /><br />Rafael
Domiciano<br/>DBA Postgres<br />Senffnet<br /><br /><div class="gmail_quote">2008/6/18 Jorge Medina <<a
href="mailto:jorge@bsdchile.cl">jorge@bsdchile.cl</a>>:<br/><blockquote class="gmail_quote" style="border-left: 1px
solidrgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">hi list,<br /> when I do:<br /> CREATE INDEX
name_indexON some_table (some_col);<br /> what method(hash,btree,rtree,etc.) use by default?<br /><br /> --<br /> Jorge
AndrésMedina Oliva.<br /> Systems Manager and Developer.<br /> BSDCHiLE.<br /><font color="#888888"><br /> --<br />
Sentvia pgsql-sql mailing list (<a href="mailto:pgsql-sql@postgresql.org">pgsql-sql@postgresql.org</a>)<br /> To make
changesto your subscription:<br /><a href="http://www.postgresql.org/mailpref/pgsql-sql"
target="_blank">http://www.postgresql.org/mailpref/pgsql-sql</a><br/></font></blockquote></div><br /> 

pgsql-sql by date:

Previous
From: "Jorge Medina"
Date:
Subject: index find method?
Next
From: "Fernando Hevia"
Date:
Subject: Re: using calculated column in where-clause