Postgres Pro
Downloads
Home   >   mailing lists

Re: Conversion of string to int using digits at beginning - Mailing list pgsql-general

From Andrus
Subject Re: Conversion of string to int using digits at beginning
Date
Msg-id 1666650D700740F4A860045D28981BE6@andrusnotebook
Whole thread Raw
In response to Re: Conversion of string to int using digits at beginning  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: Conversion of string to int using digits at beginning
Next
From: "Bayless Kirtley"
Date:
Subject: Re: MS Access and PostgreSQL - a warning to people thinking about it