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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
