Received: from presence1.observatoiredesmarques.fr (presence1.observatoiredesmarques.fr [194.98.239.193]) by hub.org (8.9.3/8.9.3) with ESMTP id FAA25903 for ; Thu, 18 May 2000 05:13:00 -0400 (EDT) (envelope-from christine@presence1.observatoiredesmarques.fr) Received: (from christine@localhost) by presence1.observatoiredesmarques.fr (8.9.1/_ODM_070798) id JAA06925 for pgsql-sql@postgresql.org; Thu, 18 May 2000 09:35:55 GMT Date: Thu, 18 May 2000 09:35:55 GMT From: christine@observatoiredesmarques.fr Message-Id: <200005180935.JAA06925@presence1.observatoiredesmarques.fr> To: pgsql-sql@postgresql.org Subject: translate from oracle X-Archive-Number: 200005/43 I try to translate a database to postgresql from oracle. there is the function "SOUNDEX" that i didn't find in Postgresql. For example soundex("jule") will give J240. soundex("salopio") will give S326. i am not sure of the result, but this example will give you an idea of this function. Did you know an similar function in postgresql? Thanks. christine.