Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 93FA39FBE81
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  2 Aug 2007 11:09:35 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 97182-01 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  2 Aug 2007 11:09:29 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from an-out-0708.google.com (an-out-0708.google.com
 [209.85.132.240])
	by postgresql.org (Postfix) with ESMTP id 626C69FBE8F
	for <pgsql-sql@postgresql.org>; Thu,  2 Aug 2007 11:09:29 -0300 (ADT)
Received: by an-out-0708.google.com with SMTP id c36so92263ana
	for <pgsql-sql@postgresql.org>; Thu, 02 Aug 2007 07:09:27 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
	b=kKSPMrMTw1IQQXbFKebFsStAFrX/1ddpmOVGzFEWdRLGB0pVWO+kBhSfsv/qgZHXrha+9yieyraI2IrEjkWgTf1+5dB2QjaHmJ+GkXbHzWoyQ82KQLq+lCeJsES332id59jTuy5koWwHf8hhmGs1VHNVU6wfoOezuFilSxBVVko=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=SjyIdhUUDQR32RUM0wGAcW6/6e+HjRhZ/UgOmBP2/plJK/ucdZ6OuZt5pcE0TjDBeDP3CfBXbUqqm27Cqp0EKArjzE0EV634kG3QYiEDz4IXljfB8YtPGygRjlWRLOF8Yio6eTeuU8EDNMKL2tZJgmPtslSqig+fVb2ePtjCMjY=
Received: by 10.100.93.5 with SMTP id q5mr1072843anb.1186063339462;
	Thu, 02 Aug 2007 07:02:19 -0700 (PDT)
Received: by 10.100.154.19 with HTTP; Thu, 2 Aug 2007 07:02:19 -0700 (PDT)
Message-ID: <5dea05d0708020702o2a2f66fan69d6c0e2e60a3f26@mail.gmail.com>
Date: Thu, 2 Aug 2007 16:02:19 +0200
From: "Elena Camossi" <elena.camossi@gmail.com>
To: pgsql-sql@postgresql.org
Subject: GiST index implementation
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_65211_6636539.1186063339423"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200708/12
X-Sequence-Number: 28950

------=_Part_65211_6636539.1186063339423
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi all,

what is the default implementation for GiST index? B-Tree or R-Tree?
That is, if i execute the following SQL command:

     CREATE index ON table USING Gist (column)

what is the type of the index that is actually built?

If I specify R-Tree instead, with:

     CREATE index ON table USING Rtree (column)

I got this message:

     NOTICE:  substituting access method "gist" for obsolete method "rtree"

and when I look at the SQL code that created the index in pgAdmin, I found
again

    CREATE index ON table USING Gist (column).

How can I specify in SQL one of the two implementations provided (e.g.
R-Tree)?


Thank you for helping.

Regards,
-Elena

------=_Part_65211_6636539.1186063339423
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi all,<br><br>what is the default implementation for GiST index? B-Tree or R-Tree?<br>That is, if i execute the following SQL command:<br><br>&nbsp;&nbsp;&nbsp;&nbsp; CREATE index ON table USING Gist (column)<br><br>what is the type of the index that is actually built?
<br><br>If I specify R-Tree instead, with:<br><br>&nbsp;&nbsp;&nbsp;&nbsp; CREATE index ON table USING Rtree (column)<br><br>I got this message:<br><br>&nbsp;&nbsp;&nbsp;&nbsp; NOTICE:&nbsp; substituting access method &quot;gist&quot; for obsolete method &quot;rtree&quot;
<br><br>and when I look at the SQL code that created the index in pgAdmin, I found again <br><br>&nbsp;&nbsp;&nbsp; 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>

------=_Part_65211_6636539.1186063339423--