diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2005-07-21 04:15:04 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2005-07-21 04:15:04 +0000 |
commit | 3976899f295c336b2a40c7fd1b4f1c345a45a446 (patch) | |
tree | 3dce1de87b701bb212a94fc0cfad2ab5ceec82dc /contrib/btree_gist/btree_gist.sql.in | |
parent | a536b2dd80f29464b0461e3980043ec4a822e820 (diff) | |
download | postgresql-3976899f295c336b2a40c7fd1b4f1c345a45a446.tar.gz postgresql-3976899f295c336b2a40c7fd1b4f1c345a45a446.zip |
Fix storage size for btree_gist interval indexes. Fix penalty
calculations for interval and time/timetz to behave sanely for both
integer and float timestamps; up to now I think it's been doing
something pretty strange...
Diffstat (limited to 'contrib/btree_gist/btree_gist.sql.in')
-rw-r--r-- | contrib/btree_gist/btree_gist.sql.in | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/contrib/btree_gist/btree_gist.sql.in b/contrib/btree_gist/btree_gist.sql.in index a5f7ae3ffa0..c4c260947e9 100644 --- a/contrib/btree_gist/btree_gist.sql.in +++ b/contrib/btree_gist/btree_gist.sql.in @@ -49,20 +49,20 @@ INPUT = gbtreekey16_in, OUTPUT = gbtreekey16_out ); -CREATE FUNCTION gbtreekey24_in(cstring) -RETURNS gbtreekey24 +CREATE FUNCTION gbtreekey32_in(cstring) +RETURNS gbtreekey32 AS 'MODULE_PATHNAME', 'gbtreekey_in' LANGUAGE 'c' WITH (isstrict); -CREATE FUNCTION gbtreekey24_out(gbtreekey24) +CREATE FUNCTION gbtreekey32_out(gbtreekey32) RETURNS cstring AS 'MODULE_PATHNAME', 'gbtreekey_out' LANGUAGE 'c' WITH (isstrict); -CREATE TYPE gbtreekey24 ( -INTERNALLENGTH = 24, -INPUT = gbtreekey24_in, -OUTPUT = gbtreekey24_out +CREATE TYPE gbtreekey32 ( +INTERNALLENGTH = 32, +INPUT = gbtreekey32_in, +OUTPUT = gbtreekey32_out ); CREATE FUNCTION gbtreekey_var_in(cstring) @@ -697,7 +697,7 @@ AS 'MODULE_PATHNAME' LANGUAGE 'C'; CREATE FUNCTION gbt_intv_union(bytea, internal) -RETURNS gbtreekey24 +RETURNS gbtreekey32 AS 'MODULE_PATHNAME' LANGUAGE 'C'; @@ -722,7 +722,7 @@ AS FUNCTION 5 gbt_intv_penalty (internal, internal, internal), FUNCTION 6 gbt_intv_picksplit (internal, internal), FUNCTION 7 gbt_intv_same (internal, internal, internal), - STORAGE gbtreekey24; + STORAGE gbtreekey32; -- -- |