bug ?

From: Mathieu Arnold <arn_mat(at)club-internet(dot)fr>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: bug ?
Date: 2000-11-08 22:34:01
Message-ID: 3A09D4D9.1D11FDFB@club-internet.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

i've using the soundex module in the contrib for some time and
yesterday, i wanted to give a try to the soundex.sql that is with the
module. (it creates some functions and an operator).

so, what i did was :

test=# CREATE FUNCTION text_soundex(text) RETURNS text
test-# AS '/opt/pg/lib/modules/soundex.so' LANGUAGE 'c';
CREATE
test=# CREATE FUNCTION text_sx_eq(text, text) RETURNS bool AS
test-# 'select text_soundex($1) = text_soundex($2)'
test-# LANGUAGE 'sql'\g
CREATE
test=# CREATE FUNCTION text_sx_lt(text,text) RETURNS bool AS
test-# 'select text_soundex($1) < text_soundex($2)'
test-# LANGUAGE 'sql'\g
CREATE
test=# CREATE FUNCTION text_sx_gt(text,text) RETURNS bool AS
test-# 'select text_soundex($1) > text_soundex($2)'
test-# LANGUAGE 'sql';
CREATE
test=# CREATE FUNCTION text_sx_le(text,text) RETURNS bool AS
test-# 'select text_soundex($1) <= text_soundex($2)'
test-# LANGUAGE 'sql';
CREATE
test=# CREATE FUNCTION text_sx_ge(text,text) RETURNS bool AS
test-# 'select text_soundex($1) >= text_soundex($2)'
test-# LANGUAGE 'sql';
CREATE
test=# CREATE FUNCTION text_sx_ne(text,text) RETURNS bool AS
test-# 'select text_soundex($1) <> text_soundex($2)'
test-# LANGUAGE 'sql';
CREATE
test=# CREATE OPERATOR #= (leftarg=text, rightarg=text,
procedure=text_sx_eq,
test(# commutator=text_sx_eq)\g
CREATE
test=# select 'joan'::text #= 'john'::text;
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!#

and, hum, is that the expected result ? :)

psql (PostgreSQL) 7.0.3 on an intel

--
Mathieu Arnold

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-11-08 22:49:32 Re: Built-in Postgres Types as shown in Chap. 4 Programmer's Guide
Previous Message Charles Curley 2000-11-08 22:20:29 Re: [NOVICE] Re: VACUUM AND VACUUM ANALYSE