Re: [HACKERS] numeric_normalize() is a few bricks shy of a load

2014-11-05 Thread Stephen Frost
* Tom Lane (t...@sss.pgh.pa.us) wrote: > I think there's no choice but to fix this in 9.4. The only reason > it even needs discussion is that this would invalidate index entries > in beta testers' JSONB GIN indexes, such that queries would not find > entries that they did find before. I'm not sur

[HACKERS] numeric_normalize() is a few bricks shy of a load

2014-11-05 Thread Tom Lane
9.4 introduced a function numeric_normalize() whose charter is to produce a string representing a numeric, such that two numerics' string representations will compare equal if and only if the numeric values compare equal. (This is used, so far, only by GIN indexes on JSONB.) Thomas Fanghaenel poin