Commita54075a

committed

Update GiST for new pg_opclass arrangement (finally a clean solution

for haskeytype). Update GiST contrib modules too. Add linear-time splitalgorithm for R-tree GiST opclass.From Oleg Bartunov and Teodor Sigaev.

1 parent38a4c35 commita54075aCopy full SHA for a54075a

File tree

+396

-593

lines changed

+396

-593

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -86,7 +86,7 @@ CREATE FUNCTION g_int_decompress(opaque) RETURNS opaque`
`86`	`86`	`AS 'MODULE_PATHNAME' LANGUAGE 'c';`
`87`	`87`
`88`	`88`	`CREATE FUNCTION g_int_penalty(opaque,opaque,opaque) RETURNS opaque`
`89`		`-AS 'MODULE_PATHNAME' LANGUAGE 'c';`
	`89`	`+AS 'MODULE_PATHNAME' LANGUAGE 'c' with (isstrict);`
`90`	`90`
`91`	`91`	`CREATE FUNCTION g_int_picksplit(opaque, opaque) RETURNS opaque`
`92`	`92`	`AS 'MODULE_PATHNAME' LANGUAGE 'c';`
`@@ -105,7 +105,7 @@ INSERT INTO pg_opclass (opcamid, opcname, opcintype, opcdefault, opckeytype)`
`105`	`105`	`'gist__int_ops',`
`106`	`106`	`(SELECT oid FROM pg_type WHERE typname = '_int4'),`
`107`	`107`	`true,`
`108`		`-(SELECT oid FROM pg_type WHERE typname = '_int4'));`
	`108`	`+0);`
`109`	`109`
`110`	`110`
`111`	`111`	`-- get the comparators for _intments and store them in a tmp table`
`@@ -252,7 +252,7 @@ INSERT INTO pg_opclass (opcamid, opcname, opcintype, opcdefault, opckeytype)`
`252`	`252`	`'gist__intbig_ops',`
`253`	`253`	`(SELECT oid FROM pg_type WHERE typname = '_int4'),`
`254`	`254`	`false,`
`255`		`-(SELECT oid FROM pg_type WHERE typname = '_int4'));`
	`255`	`+0);`
`256`	`256`
`257`	`257`
`258`	`258`	`-- get the comparators for _intments and store them in a tmp table`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -19,7 +19,7 @@ select count(*) from boxtmp where b && '(1000,1000,0,0)'::box;`
`19`	`19`	`(1 row)`
`20`	`20`
`21`	`21`	`drop index bix;`
`22`		`-create index bix on boxtmp using gist (b gist_box_ops);`
	`22`	`+create index bix on boxtmp using gist (b);`
`23`	`23`	`select count(*) from boxtmp where b && '(1000,1000,0,0)'::box;`
`24`	`24`	`count`
`25`	`25`	`-------`
`@@ -36,7 +36,7 @@ select count(*) from polytmp where p && '(1000,1000),(0,0)'::polygon;`
`36`	`36`	`(1 row)`
`37`	`37`
`38`	`38`	`drop index pix;`
`39`		`-create index pix on polytmp using gist (p gist_poly_ops);`
	`39`	`+create index pix on polytmp using gist (p);`
`40`	`40`	`select count(*) from polytmp where p && '(1000,1000),(0,0)'::polygon;`
`41`	`41`	`count`
`42`	`42`	`-------`

Comments

(0)