X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 41BBB9FA509
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  1 May 2006 05:50:32 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 51898-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  1 May 2006 05:50:25 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.189])
	by postgresql.org (Postfix) with ESMTP id CE62E9FA4B3
	for <pgsql-sql@postgresql.org>; Mon,  1 May 2006 05:50:25 -0300 (ADT)
Received: by nproxy.gmail.com with SMTP id b2so1333360nfe
	for <pgsql-sql@postgresql.org>; Mon, 01 May 2006 01:50:24 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:organization:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding;
	b=pnM+Vjv1yyhGV6ExXumsHJiniiy42bC3lnhcGwJA+yPGL5+XvWEWZFgTcNBjD0VTysGBq2xKyu4EiFR1hLf0aLVTKdZGOzHUw7KUKwP3WaVWKpP8cOLTFAqOSpEiYqbpqM12bz51su3EkxVYuSRiD3RNou8yXfKw0x4t1LlmiAc=
Received: by 10.49.59.2 with SMTP id m2mr6501605nfk;
	Mon, 01 May 2006 01:50:23 -0700 (PDT)
Received: from ?192.168.10.4? ( [86.218.58.122])
	by mx.gmail.com with ESMTP id o53sm998352nfa.2006.05.01.01.50.16;
	Mon, 01 May 2006 01:50:21 -0700 (PDT)
Message-ID: <4455CBFD.3090200@gmail.com>
Date: Mon, 01 May 2006 10:51:09 +0200
From: Guillaume LELARGE <guillaume.lelarge@gmail.com>
Organization: traduc.org, postgresqlfr.org
User-Agent: Thunderbird 1.5 (X11/20060309)
MIME-Version: 1.0
To: tnodev <tnodev@free.fr>
CC: pgsql-sql@postgresql.org
Subject: Re: Like with special character
References: <4455BAD6.60001@free.fr>
In-Reply-To: <4455BAD6.60001@free.fr>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200605/3
X-Sequence-Number: 25034

Hi,

tnodev a écrit :
> I'm using postGre with tables which contain French character (éèçàù...).
> Is there a fonction which performs a like in replacing é (e cute) by e ?
> 

select translate('forêt', 'àâäéèêëîïôöùûü', 'aaaeeeeiioouuu');

Change the first word (forêt) by the string you want characters to be
replaced.

For more, see :
  http://docs.postgresqlfr.org/pgsql-8.1.3-fr/functions-string.html
    (french docs)
  http://www.postgresql.org/docs/8.1/interactive/functions-string.html
    (english docs)

BTW, it is PostgreSQL, not postGre.

Regards,


-- 
Guillaume.