Postgres Pro
Downloads
Home   >   mailing lists

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

From Sam Mason
Subject Re: Conversion of string to int using digits at beginning
Date
Msg-id 20081118175812.GT2459@frubble.xen.chris-lamb.co.uk
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 
On Tue, Nov 18, 2008 at 05:51:08PM +0000, Raymond O'Donnell wrote:
> You could use a regular expression in substring() to get just the
> numeric bits.

Thanks, never noticed that substring would accept a regexp before.
Syntax is a bit baroque, but it seems to work!


  Sam

pgsql-general by date:

Previous
From: Erwin Moller
Date:
Subject: Re: Foreign Key 'walker'?
Next
From: "Andrus"
Date:
Subject: Re: Conversion of string to int using digits at beginning