Re: [GENERAL] Spliting a string in plpgsql

2007-05-08 Thread Albe Laurenz
> Jasbinder Singh Bali <[EMAIL PROTECTED]> schrieb: >> I'm writing a function in plpgsql and i need to do the following: >> >> I have a string in the following format. >> >> mail.yahoo.com >> >> In this string, i need to figure out the number of dots in it and split the >> string into two on las

Re: [GENERAL] Spliting a string in plpgsql

2007-05-08 Thread Andreas Kretschmer
Jasbinder Singh Bali <[EMAIL PROTECTED]> schrieb: > Hi, > I'm writing a function in plpgsql and i need to do the following: > > I have a string in the following format. > > _m_a_i_l_._y_a_h_o_o_._c_o_m > > In this string, i need to figure out the number of dots in it and split the