| From: | Raphaël Berbain <raphael(dot)berbain(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | width_bucket issue |
| Date: | 2018-07-24 20:02:41 |
| Message-ID: | CAHcVTKFQrpG05z2e9esWdN-Mip4fp4vcf5Z=6NrixBvFsZyXmg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
The width_bucket function doesn't seem to work the way I'd expect:
postgres=# SELECT width_bucket(4, 0, 12, 3) b1, width_bucket(4 :: NUMERIC,
0, 12, 3) b2;
b1 | b2
----+----
2 | 1
(1 row)
I'd expect b1 = b2 = 2. What am I missing?
This is with 10.4 running as a docker container, if it matters:
postgres=# SELECT version();
version
---------------------------------------------------------------------------------------
PostgreSQL 10.4 (Debian 10.4-2.pgdg90+1) on x86_64-pc-linux-gnu, compiled
by gcc (Debi
(1 row)
TIA,
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rory Falloon | 2018-07-24 20:08:38 | Re: Dealing with latency to replication slave; what to do? |
| Previous Message | Andres Freund | 2018-07-24 20:02:13 | Re: Dealing with latency to replication slave; what to do? |