X-Git-Url: http://git.sourceforge.jp/view?a=blobdiff_plain;f=pg_bigm--1.1--1.2.sql;h=ba52bcaedd3ef27b5d8d84e3daa259bc56172e16;hb=bec3df839c48bb359a00b68605ddc28400d02f5e;hp=a2bb7e9aa8259dc8a15b9f1faf6c1f0ba8f60987;hpb=0b09e86e2f35b2e64e290153c3def5f2ab72b940;p=pgbigm%2Fpg_bigm.git

diff --git a/pg_bigm--1.1--1.2.sql b/pg_bigm--1.1--1.2.sql
index a2bb7e9..ba52bca 100644
--- a/pg_bigm--1.1--1.2.sql
+++ b/pg_bigm--1.1--1.2.sql
@@ -4,10 +4,10 @@
 /* triConsistent function is available only in 9.4 or later */
 DO $$
 DECLARE
-    pgversion TEXT;
+    pgversion INTEGER;
 BEGIN
-    SELECT current_setting('server_version_num') INTO pgversion;
-    IF pgversion >= '90400' THEN
+    SELECT current_setting('server_version_num')::INTEGER INTO pgversion;
+    IF pgversion >= 90400 THEN
         CREATE FUNCTION gin_bigm_triconsistent(internal, int2, text, int4, internal, internal, internal)
         RETURNS "char"
         AS 'MODULE_PATHNAME'
@@ -21,10 +21,10 @@ $$;
 /* Label whether the function is deemed safe for parallelism */
 DO $$
 DECLARE
-    pgversion TEXT;
+    pgversion INTEGER;
 BEGIN
-    SELECT current_setting('server_version_num') INTO pgversion;
-    IF pgversion >= '90600' THEN
+    SELECT current_setting('server_version_num')::INTEGER INTO pgversion;
+    IF pgversion >= 90600 THEN
         ALTER FUNCTION show_bigm(text) PARALLEL SAFE;
         ALTER FUNCTION bigm_similarity(text, text) PARALLEL SAFE;
         ALTER FUNCTION bigm_similarity_op(text, text) PARALLEL SAFE;