Changes between Version 1 and Version 2 of Parcours source RHT

Timestamp:

Oct 25, 2011 10:18:51 PM (14 years ago)

Author:

cedric

Comment:

--

Parcours source RHT

@@ -1 +1 @@
 back to first page[..][[BR]]
 back to ["RHT"][[BR]]
+
+{{{
+#!sql
+-- script de calcul des distances sources
+set search_path to rht,public;
+select cast(ltree2text(subltree(chemin,0,1)) as integer) from rht_topology 
+/*
+AJOUT D'UN INDEX
+ltree supports several types of indexes that can speed up the indicated operators:
+    B-tree index over ltree: <, <=, =, >=, >
+    GiST index over ltree: <, <=, =, >=, >, @>, <@, @, ~, ? 
+*/
+CREATE INDEX chemin_gist_index ON rht_topology USING GIST (chemin);
+}}}