Re: Like with special character

From: TNO <tnodev(at)free(dot)fr>
To:
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Like with special character
Date: 2006-05-01 14:35:39
Message-ID: 44561CBB.4050603@free.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)sai(dot)msu(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Guy Fraser 2006-05-01 15:57:54 Re: LinkedList
Previous Message Oleg Bartunov 2006-05-01 12:55:46 Re: Like with special character