Re: numeric_to_number() function skipping some digits

From: Brendan Jurd <direvus(at)gmail(dot)com>
To: Jeevan Chalke <jeevan(dot)chalke(at)enterprisedb(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: numeric_to_number() function skipping some digits
Date: 2009-09-21 07:07:16
Message-ID: 37ed240d0909210007v6ac71caah3ac840e00cee2a76@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2009/9/21 Brendan Jurd <direvus(at)gmail(dot)com>:
>
> # SELECT regexp_replace('34,50', E'[\\d.]', '', 'g')::numeric;
> 3450
>

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2009-09-21 07:20:43 Re: Linux LSB init script
Previous Message Brendan Jurd 2009-09-21 07:06:06 Re: numeric_to_number() function skipping some digits