Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitffab82f

Browse files
committed
Update fuzzystrmatch extension for parallel query.
All functions provided by this extension are PARALLEL SAFE.Andreas Karlsson
1 parent50e5226 commitffab82f

File tree

4 files changed

+29
-13
lines changed

4 files changed

+29
-13
lines changed

‎contrib/fuzzystrmatch/Makefile

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,8 @@ MODULE_big = fuzzystrmatch
44
OBJS = fuzzystrmatch.o dmetaphone.o$(WIN32RES)
55

66
EXTENSION = fuzzystrmatch
7-
DATA = fuzzystrmatch--1.0.sql fuzzystrmatch--unpackaged--1.0.sql
7+
DATA = fuzzystrmatch--1.1.sql fuzzystrmatch--1.0--1.1.sql\
8+
fuzzystrmatch--unpackaged--1.0.sql
89
PGFILEDESC = "fuzzystrmatch - similarities and distance between strings"
910

1011
ifdefUSE_PGXS
Lines changed: 15 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,15 @@
1+
/* contrib/fuzzystrmatch/fuzzystrmatch--1.0--1.1.sql*/
2+
3+
-- complain if script is sourced in psql, rather than via ALTER EXTENSION
4+
\echo Use"ALTER EXTENSION fuzzystrmatch UPDATE TO '1.1'" to load this file. \quit
5+
6+
ALTERFUNCTION levenshtein(text,text) PARALLEL SAFE;
7+
ALTERFUNCTION levenshtein(text,text,int,int,int) PARALLEL SAFE;
8+
ALTERFUNCTION levenshtein_less_equal(text,text,int) PARALLEL SAFE;
9+
ALTERFUNCTION levenshtein_less_equal(text,text,int,int,int,int) PARALLEL SAFE;
10+
ALTERFUNCTION metaphone(text,int) PARALLEL SAFE;
11+
ALTERFUNCTION soundex(text) PARALLEL SAFE;
12+
ALTERFUNCTION text_soundex(text) PARALLEL SAFE;
13+
ALTERFUNCTION difference(text,text) PARALLEL SAFE;
14+
ALTERFUNCTION dmetaphone(text) PARALLEL SAFE;
15+
ALTERFUNCTION dmetaphone_alt(text) PARALLEL SAFE;
Lines changed: 11 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -1,44 +1,44 @@
1-
/* contrib/fuzzystrmatch/fuzzystrmatch--1.0.sql*/
1+
/* contrib/fuzzystrmatch/fuzzystrmatch--1.1.sql*/
22

33
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
44
\echo Use"CREATE EXTENSION fuzzystrmatch" to load this file. \quit
55

66
CREATEFUNCTIONlevenshtein (text,text) RETURNSint
77
AS'MODULE_PATHNAME','levenshtein'
8-
LANGUAGE C IMMUTABLE STRICT;
8+
LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;
99

1010
CREATEFUNCTIONlevenshtein (text,text,int,int,int) RETURNSint
1111
AS'MODULE_PATHNAME','levenshtein_with_costs'
12-
LANGUAGE C IMMUTABLE STRICT;
12+
LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;
1313

1414
CREATEFUNCTIONlevenshtein_less_equal (text,text,int) RETURNSint
1515
AS'MODULE_PATHNAME','levenshtein_less_equal'
16-
LANGUAGE C IMMUTABLE STRICT;
16+
LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;
1717

1818
CREATEFUNCTIONlevenshtein_less_equal (text,text,int,int,int,int) RETURNSint
1919
AS'MODULE_PATHNAME','levenshtein_less_equal_with_costs'
20-
LANGUAGE C IMMUTABLE STRICT;
20+
LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;
2121

2222
CREATEFUNCTIONmetaphone (text,int) RETURNStext
2323
AS'MODULE_PATHNAME','metaphone'
24-
LANGUAGE C IMMUTABLE STRICT;
24+
LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;
2525

2626
CREATEFUNCTIONsoundex(text) RETURNStext
2727
AS'MODULE_PATHNAME','soundex'
28-
LANGUAGE C IMMUTABLE STRICT;
28+
LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;
2929

3030
CREATEFUNCTIONtext_soundex(text) RETURNStext
3131
AS'MODULE_PATHNAME','soundex'
32-
LANGUAGE C IMMUTABLE STRICT;
32+
LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;
3333

3434
CREATEFUNCTIONdifference(text,text) RETURNSint
3535
AS'MODULE_PATHNAME','difference'
36-
LANGUAGE C IMMUTABLE STRICT;
36+
LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;
3737

3838
CREATEFUNCTIONdmetaphone (text) RETURNStext
3939
AS'MODULE_PATHNAME','dmetaphone'
40-
LANGUAGE C IMMUTABLE STRICT;
40+
LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;
4141

4242
CREATEFUNCTIONdmetaphone_alt (text) RETURNStext
4343
AS'MODULE_PATHNAME','dmetaphone_alt'
44-
LANGUAGE C IMMUTABLE STRICT;
44+
LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;
Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
# fuzzystrmatch extension
22
comment = 'determine similarities and distance between strings'
3-
default_version = '1.0'
3+
default_version = '1.1'
44
module_pathname = '$libdir/fuzzystrmatch'
55
relocatable = true

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp