summaryrefslogtreecommitdiff
path: root/contrib/fulltextindex
diff options
context:
space:
mode:
authorPeter Eisentraut2006-02-27 16:09:50 +0000
committerPeter Eisentraut2006-02-27 16:09:50 +0000
commit7f4f42fa100872507ca10d8e0f7d923acc266ee8 (patch)
treec297cd70679cb60b470f8199ab707d80de108d5c /contrib/fulltextindex
parentfe83b3ebc6b8d65fbb14100bdc476b7dbc32454c (diff)
Clean up CREATE FUNCTION syntax usage in contrib and elsewhere, in
particular get rid of single quotes around language names and old WITH () construct.
Diffstat (limited to 'contrib/fulltextindex')
-rw-r--r--contrib/fulltextindex/README.fti2
-rw-r--r--contrib/fulltextindex/fti.c2
-rw-r--r--contrib/fulltextindex/fti.pl2
-rw-r--r--contrib/fulltextindex/fti.sql.in2
4 files changed, 4 insertions, 4 deletions
diff --git a/contrib/fulltextindex/README.fti b/contrib/fulltextindex/README.fti
index 2425288b83..c2a24096c3 100644
--- a/contrib/fulltextindex/README.fti
+++ b/contrib/fulltextindex/README.fti
@@ -58,7 +58,7 @@ sub-string will fit.
The create the function that contains the trigger::
create function fti() returns trigger as
- '/path/to/fti.so' language 'C';
+ '/path/to/fti.so' language C;
And finally define the trigger on the 'cds' table:
diff --git a/contrib/fulltextindex/fti.c b/contrib/fulltextindex/fti.c
index a3ac6da586..9e120dc892 100644
--- a/contrib/fulltextindex/fti.c
+++ b/contrib/fulltextindex/fti.c
@@ -22,7 +22,7 @@
*
* -- Create the SQL function based on the compiled shared object
* create function fti() returns trigger as
- * '/usr/local/pgsql/lib/contrib/fti.so' language 'C';
+ * '/usr/local/pgsql/lib/contrib/fti.so' language C;
*
* -- Create the FTI table
* create table product_fti (string varchar(255), id oid) without oids;
diff --git a/contrib/fulltextindex/fti.pl b/contrib/fulltextindex/fti.pl
index 17f000149b..4feb51964f 100644
--- a/contrib/fulltextindex/fti.pl
+++ b/contrib/fulltextindex/fti.pl
@@ -29,7 +29,7 @@
#
# create function fti() returns trigger as
# '/path/to/fti/file/fti.so'
-# language 'C';
+# language C;
#
# create trigger my_fti_trigger after update or insert or delete
# on mytable
diff --git a/contrib/fulltextindex/fti.sql.in b/contrib/fulltextindex/fti.sql.in
index 93eff0f633..c060ee8757 100644
--- a/contrib/fulltextindex/fti.sql.in
+++ b/contrib/fulltextindex/fti.sql.in
@@ -3,4 +3,4 @@ SET search_path = public;
CREATE OR REPLACE FUNCTION fti() RETURNS trigger AS
'MODULE_PATHNAME', 'fti'
- LANGUAGE 'C' VOLATILE CALLED ON NULL INPUT;
+ LANGUAGE C VOLATILE CALLED ON NULL INPUT;