Re: index find method?

------=_Part_7402_12965440.1213805006553
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hello,

The Default method is btree, that is the commonly method used in the
indexes.

Rafael Domiciano
DBA Postgres
Senffnet

2008/6/18 Jorge Medina <jorge@[EMAIL PROTECTED]
>:

> hi list,
> when I do:
> CREATE INDEX name_index ON some_table (some_col);
> what method(hash,btree,rtree,etc.) use by default?
>
> --
> Jorge Andr=E9s Medina Oliva.
> Systems Manager and Developer.
> BSDCHiLE.
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@[EMAIL PROTECTED]
)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>

------=_Part_7402_12965440.1213805006553
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

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=3D"gmail_quote">2008/6/18 Jorge Medina &lt;<a
href=3D"mailto:jo=
rge@[EMAIL PROTECTED]
">jorge@[EMAIL PROTECTED]
>&gt;:<br>
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204,
=
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">hi list,<br>
when I do:<br>
CREATE INDEX name_index ON some_table (some_col);<br>
what method(hash,btree,rtree,etc.) use by default?<br>
<br>
--<br>
Jorge Andr=E9s Medina Oliva.<br>
Systems Manager and Developer.<br>
BSDCHiLE.<br>
<font color=3D"#888888"><br>
--<br>
Sent via pgsql-sql mailing list (<a
href=3D"mailto:pgsql-sql@[EMAIL PROTECTED]
">pgsql-sql@[EMAIL PROTECTED]
>)<br>
To make changes to your subscription:<br>
<a href=3D"http://www.postgresql.org/mailpref/pgsql-sql"
target=3D"_blank">=
http://www.postgresql.org/mailpref/pgsql-sql</a><br>
</font></blockquote></div><br>

------=_Part_7402_12965440.1213805006553--