Postgres Pro
Downloads
Home   >   mailing lists

Re: numeric_to_number() function skipping some digits - Mailing list pgsql-hackers

From Brendan Jurd
Subject Re: numeric_to_number() function skipping some digits
Date
Msg-id 37ed240d0909210007v6ac71caah3ac840e00cee2a76@mail.gmail.com
Whole thread Raw
In response to Re: numeric_to_number() function skipping some digits  (Brendan Jurd <direvus@gmail.com>)
List pgsql-hackers
Tree view 
2009/9/21 Brendan Jurd <direvus@gmail.com>:
>
> # SELECT regexp_replace('34,50', E'[\\d.]', '', 'g')::numeric;
> 3450
>

Sorry, that regex ought to have read E'[^\\d.]'.

pgsql-hackers by date:

Previous
From: Brendan Jurd
Date:
Subject: Re: numeric_to_number() function skipping some digits
Next
From: Peter Eisentraut
Date:
Subject: Re: Linux LSB init script