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

[GENERAL] Spliting a string in plpgsql

2007-05-08 Thread Jasbinder Singh Bali
Hi, 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 last but one dot. Is there any way to accomplish this. Please let me know