← Back to branch summary

~ubuntu-branches/ubuntu/natty/postgresql-8.4/natty-security

« back to all changes in this revision

Viewing changes to contrib/pg_trgm/pg_trgm.sql.in

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2009-07-11 16:59:35 UTC
  • mfrom: (5.1.1 karmic)
  • Revision ID: james.westby@ubuntu.com-20090711165935-jfwin6gfrxf0gfsi
Tags: 8.4.0-2
http://bugs.debian.org/536139
* debian/libpq-dev.install: Ship catalog/genbki.h. (Closes: #536139)
* debian/rules: Drop --enable-cassert for final release.

Show diffs side-by-side

added added

removed removed

Lines of Context:
contrib/pg_trgm/pg_trgm.sql.in
1
 
/* $PostgreSQL: pgsql/contrib/pg_trgm/pg_trgm.sql.in,v 1.9 2009/03/25 22:19:01 tgl Exp $ */
 
1
/* $PostgreSQL: pgsql/contrib/pg_trgm/pg_trgm.sql.in,v 1.10 2009/06/11 18:30:03 tgl Exp $ */
2
2
 
3
3
-- Adjust this setting to control where the objects get created.
4
4
SET search_path = public;
58
58
CREATE OR REPLACE FUNCTION gtrgm_consistent(internal,text,int,oid,internal)
59
59
RETURNS bool
60
60
AS 'MODULE_PATHNAME'
61
 
LANGUAGE C IMMUTABLE;
 
61
LANGUAGE C IMMUTABLE STRICT;
62
62
 
63
63
CREATE OR REPLACE FUNCTION gtrgm_compress(internal)
64
64
RETURNS internal
65
65
AS 'MODULE_PATHNAME'
66
 
LANGUAGE C IMMUTABLE;
 
66
LANGUAGE C IMMUTABLE STRICT;
67
67
 
68
68
CREATE OR REPLACE FUNCTION gtrgm_decompress(internal)
69
69
RETURNS internal
70
70
AS 'MODULE_PATHNAME'
71
 
LANGUAGE C IMMUTABLE;
 
71
LANGUAGE C IMMUTABLE STRICT;
72
72
 
73
73
CREATE OR REPLACE FUNCTION gtrgm_penalty(internal,internal,internal)
74
74
RETURNS internal
75
75
AS 'MODULE_PATHNAME'
76
 
LANGUAGE C STRICT IMMUTABLE;
 
76
LANGUAGE C IMMUTABLE STRICT;
77
77
 
78
78
CREATE OR REPLACE FUNCTION gtrgm_picksplit(internal, internal)
79
79
RETURNS internal
80
80
AS 'MODULE_PATHNAME'
81
 
LANGUAGE C IMMUTABLE;
 
81
LANGUAGE C IMMUTABLE STRICT;
82
82
 
83
83
CREATE OR REPLACE FUNCTION gtrgm_union(bytea, internal)
84
84
RETURNS _int4
85
85
AS 'MODULE_PATHNAME'
86
 
LANGUAGE C IMMUTABLE;
 
86
LANGUAGE C IMMUTABLE STRICT;
87
87
 
88
88
CREATE OR REPLACE FUNCTION gtrgm_same(gtrgm, gtrgm, internal)
89
89
RETURNS internal
90
90
AS 'MODULE_PATHNAME'
91
 
LANGUAGE C IMMUTABLE;
 
91
LANGUAGE C IMMUTABLE STRICT;
92
92
 
93
93
-- create the operator class for gist
94
94
CREATE OPERATOR CLASS gist_trgm_ops
108
108
CREATE OR REPLACE FUNCTION gin_extract_trgm(text, internal)
109
109
RETURNS internal
110
110
AS 'MODULE_PATHNAME'
111
 
LANGUAGE C IMMUTABLE;
 
111
LANGUAGE C IMMUTABLE STRICT;
112
112
 
113
113
CREATE OR REPLACE FUNCTION gin_extract_trgm(text, internal, int2, internal, internal)
114
114
RETURNS internal
115
115
AS 'MODULE_PATHNAME'
116
 
LANGUAGE C IMMUTABLE;
 
116
LANGUAGE C IMMUTABLE STRICT;
117
117
 
118
118
CREATE OR REPLACE FUNCTION gin_trgm_consistent(internal, int2, text, int4, internal, internal)
119
119
RETURNS bool
120
120
AS 'MODULE_PATHNAME'
121
 
LANGUAGE C IMMUTABLE;
 
121
LANGUAGE C IMMUTABLE STRICT;
122
122
 
123
123
-- create the operator class for gin
124
124
CREATE OPERATOR CLASS gin_trgm_ops