Re: jsonb and nested hstore

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Peter Geoghegan <pg(at)heroku(dot)com>
Cc: obartunov(at)gmail(dot)com, Andres Freund <andres(at)2ndquadrant(dot)com>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: jsonb and nested hstore
Date: 2014-03-04 12:48:48
Message-ID: 5315CBB0.6000708@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On Tue, Mar 4, 2014 at 2:44 AM, Teodor Sigaev <teodor(at)sigaev(dot)ru> wrote:
>> Do we have function to trim right zeros in numeric?

Fixed, pushed to github
(https://github.com/feodor/postgres/tree/jsonb_and_hstore). Now it used
hash_numeric to index numeric value. As I can see, it provides needed trim and
doesn't depend on locale. Possible mismatch (the same hash value for different
numeric valye) will rechecked anyway - interested operations set recheck flag.

--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Atri Sharma 2014-03-04 13:03:57 Re: ALTER TABLE lock strength reduction patch is unsafe
Previous Message Pavel Stehule 2014-03-04 12:46:09 Re: patch: option --if-exists for pg_dump