Re:

On Thu, Jun 12, 2003 at 10:16:13AM +0100, mogas(at)aveiro-digital(dot)net wrote:

> I have a varchar variable that have inside something like 8:50. I need to
> broke it and cast each part into two integer variables (x=8 and y=50).

> If someone know how to do this please tell me to this mail if possible.

I think you can do something like
SELECT split_part('8:50', ':', 1), split_part('8:50', ':', 2);

--
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
"La realidad se compone de muchos sueos, todos ellos diferentes,
pero en cierto aspecto, parecidos..." (Yo, hablando de sueos erticos)