Re: [HACKERS] Fix number skipping in to_number - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Fix number skipping in to_number
Date
Msg-id 20534.1510513242@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Fix number skipping in to_number  (Oliver Ford <ojford@gmail.com>)
Responses Re: [HACKERS] Fix number skipping in to_number  (Oliver Ford <ojford@gmail.com>)
List pgsql-hackers
Oliver Ford <ojford@gmail.com> writes:
> [ 0001-apply-number-v3.patch ]

I looked at this patch briefly and have a couple of comments:

* It seems entirely wrong to be matching to L_thousands_sep in the
NUM_COMMA case; that format code is by definition not locale aware,
so it should be matching to plain ',' independently of locale.

* Don't we need to fix the NUM_L (currency symbol) case in the
same manner?  (The NUM_D and NUM_S cases are handled in
NUM_numpart_from_char and seem ok at a quick glance.)

* I'm not in love with the noadd flag.  Other places in this
switch that want to skip the final increment do it with
"continue", and I think this should do likewise.
        regards, tom lane


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

pgsql-hackers by date:

Previous
From: Andrey Borodin
Date:
Subject: Re: [HACKERS] New gist vacuum.
Next
From: Joe Conway
Date:
Subject: Re: [HACKERS] Row Level Security Bug ?