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 795909FA4A0 for ; Mon, 1 May 2006 11:35:56 -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 29389-02 for ; Mon, 1 May 2006 11:35:45 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id DFB269F9DCD for ; Mon, 1 May 2006 11:35:45 -0300 (ADT) Received: from smtp12.wanadoo.fr (smtp12.wanadoo.fr [193.252.22.20]) by svr4.postgresql.org (Postfix) with ESMTP id E1FE25B847C for ; Mon, 1 May 2006 14:35:44 +0000 (GMT) Received: from me-wanadoo.net (localhost [127.0.0.1]) by mwinf1202.wanadoo.fr (SMTP Server) with ESMTP id D6FC71C00098 for ; Mon, 1 May 2006 16:35:39 +0200 (CEST) Received: from [192.168.2.50] (LNeuilly-152-21-104-92.w193-253.abo.wanadoo.fr [193.253.37.92]) by mwinf1202.wanadoo.fr (SMTP Server) with ESMTP id A9D8E1C00091 for ; Mon, 1 May 2006 16:35:39 +0200 (CEST) X-ME-UUID: 20060501143539695.A9D8E1C00091@mwinf1202.wanadoo.fr Message-ID: <44561CBB.4050603@free.fr> Date: Mon, 01 May 2006 16:35:39 +0200 From: TNO User-Agent: Thunderbird 1.5.0.2 (Windows/20060308) MIME-Version: 1.0 Cc: pgsql-sql@postgresql.org Subject: Re: Like with special character References: <4455BAD6.60001@free.fr> In-Reply-To: X-Enigmail-Version: 0.94.0.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/6 X-Sequence-Number: 25037 Perfect, thanks I found regex for postgreSql too, it's interesting too select * from divers where s_libelle ~* '^t(e|é|ê)' Oleg Bartunov a écrit : > On Mon, 1 May 2006, tnodev wrote: > >> Hello, >> >> I'm using postGre with tables which contain French character >> (?????...). Is there a fonction which performs a like in replacing ? >> (e cute) by e ? > > to_ascii() should helps you > >> >> thanks... >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 6: explain analyze is your friend >> > > Regards, > Oleg > _____________________________________________________________ > Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), > Sternberg Astronomical Institute, Moscow University, Russia > Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ > phone: +007(495)939-16-83, +007(495)939-23-83 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > > > -- Il n'y a pas de mauvais langage, il n'y a que des bons programmeurs