From: TNO <tnodev@free.fr>
Cc: pgsql-sql@postgresql.org
Subject: Re: Like with special character
Date: Mon, 01 May 2006 16:35:39 +0200
Message-ID: <44561CBB.4050603@free.fr> (raw)
In-Reply-To: <Pine.GSO.4.63.0605011655300.3992@ra.sai.msu.su>
References: <4455BAD6.60001@free.fr>
<Pine.GSO.4.63.0605011655300.3992@ra.sai.msu.su>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tnodev@free.fr
Subject: Re: Like with special character
In-Reply-To: <44561CBB.4050603@free.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox