Spliting a string in plpgsql - Mailing list pgsql-general

From Jasbinder Singh Bali
Subject Spliting a string in plpgsql
Date
Msg-id a47902760705080944sf043e8dp992b6a46571106e4@mail.gmail.com
Whole thread Raw
Responses Re: Spliting a string in plpgsql
List pgsql-general
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

Thanks
~Jas

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Building Pg 8.2.4 on AIX 5.3 doesn't produce shared libs?
Next
From: Sean Murphy
Date:
Subject: Idle session timeout?