Re: Conversion of string to int using digits at beginning

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Conversion of string to int using digits at beginning
Date: 2008-11-18 17:58:13
Message-ID: 20081118175812.GT2459@frubble.xen.chris-lamb.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bayless Kirtley 2008-11-18 18:00:34 Re: MS Access and PostgreSQL - a warning to people thinking about it
Previous Message Andrus 2008-11-18 17:58:00 Re: Conversion of string to int using digits at beginning