diff options
| author | Bruce Momjian <bruce@momjian.us> | 2000-06-19 13:54:50 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2000-06-19 13:54:50 +0000 |
| commit | 6de7d4fe91b1f037eb9ad612a22e972037426100 (patch) | |
| tree | 1661370f02a7ce6aa212a35b15d35f344faccad1 /contrib/soundex | |
| parent | b2c56574e1a83d4f71f72f9243423eeddbdbbe20 (diff) | |
| download | postgresql-6de7d4fe91b1f037eb9ad612a22e972037426100.tar.gz | |
Update to /contrib from Karel.
Diffstat (limited to 'contrib/soundex')
| -rw-r--r-- | contrib/soundex/Makefile | 6 | ||||
| -rw-r--r-- | contrib/soundex/README | 53 |
2 files changed, 3 insertions, 56 deletions
diff --git a/contrib/soundex/Makefile b/contrib/soundex/Makefile index bf9a0bf7bb..55e61b3ede 100644 --- a/contrib/soundex/Makefile +++ b/contrib/soundex/Makefile @@ -1,5 +1,5 @@ # -# $Header: /cvsroot/pgsql/contrib/soundex/Attic/Makefile,v 1.4 2000/06/16 18:59:13 momjian Exp $ +# $Header: /cvsroot/pgsql/contrib/soundex/Attic/Makefile,v 1.5 2000/06/19 13:54:11 momjian Exp $ # TOPDIR=../.. @@ -10,7 +10,7 @@ NAME = soundex PROGRAM = OBJS = $(NAME).o -DOCS = README +DOCS = README.$(NAME) SQLS = $(NAME).sql BINS = EXAMPLES= @@ -30,7 +30,7 @@ install: install_doc install_sql install_mod install_doc: for inst_file in $(DOCS); do \ - $(INSTALL) $(INSTL_LIB_OPTS) $$inst_file $(CONTRIB_DOCDIR)/$(DOCS).$(NAME); \ + $(INSTALL) $(INSTL_LIB_OPTS) $$inst_file $(CONTRIB_DOCDIR); \ done install_sql: diff --git a/contrib/soundex/README b/contrib/soundex/README index e3ba4ee231..e69de29bb2 100644 --- a/contrib/soundex/README +++ b/contrib/soundex/README @@ -1,53 +0,0 @@ - -SELECT text_soundex('hello world!'); - -CREATE TABLE s (nm text)\g - -insert into s values ('john')\g -insert into s values ('joan')\g -insert into s values ('wobbly')\g - -select * from s -where text_soundex(nm) = text_soundex('john')\g - -select nm from s a, s b -where text_soundex(a.nm) = text_soundex(b.nm) -and a.oid <> b.oid\g - -CREATE FUNCTION text_sx_eq(text, text) RETURNS bool AS -'select text_soundex($1) = text_soundex($2)' -LANGUAGE 'sql'\g - -CREATE FUNCTION text_sx_lt(text,text) RETURNS bool AS -'select text_soundex($1) < text_soundex($2)' -LANGUAGE 'sql'\g - -CREATE FUNCTION text_sx_gt(text,text) RETURNS bool AS -'select text_soundex($1) > text_soundex($2)' -LANGUAGE 'sql'; - -CREATE FUNCTION text_sx_le(text,text) RETURNS bool AS -'select text_soundex($1) <= text_soundex($2)' -LANGUAGE 'sql'; - -CREATE FUNCTION text_sx_ge(text,text) RETURNS bool AS -'select text_soundex($1) >= text_soundex($2)' -LANGUAGE 'sql'; - -CREATE FUNCTION text_sx_ne(text,text) RETURNS bool AS -'select text_soundex($1) <> text_soundex($2)' -LANGUAGE 'sql'; - -DROP OPERATOR #= (text,text)\g - -CREATE OPERATOR #= (leftarg=text, rightarg=text, procedure=text_sx_eq, -commutator=text_sx_eq)\g - -SELECT * -FROM s -WHERE text_sx_eq(nm,'john')\g - -SELECT * -from s -where s.nm #= 'john'; - |