| 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/
| 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 |