Re: Conversion of string to int using digits at beginning

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: <rod(at)iol(dot)ie>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Conversion of string to int using digits at beginning
Date: 2008-11-18 17:58:00
Message-ID: 1666650D700740F4A860045D28981BE6@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Raymond,

> You could use a regular expression in substring() to get just the
> numeric bits.

Thank you.
I do'nt have any experience on regex.
Can you provide a sample how to use regex to get numeric substring from
start of string ?

Andrus.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2008-11-18 17:58:13 Re: Conversion of string to int using digits at beginning
Previous Message Erwin Moller 2008-11-18 17:57:59 Re: Foreign Key 'walker'?