Postgres Pro
Downloads
Home   >   mailing lists

width_bucket issue - Mailing list pgsql-general

From Raphaël Berbain
Subject width_bucket issue
Date
Msg-id CAHcVTKFQrpG05z2e9esWdN-Mip4fp4vcf5Z=6NrixBvFsZyXmg@mail.gmail.com
Whole thread Raw
Responses Re: width_bucket issue  (Christophe Pettus <xof@thebuild.com>)
List pgsql-general
Tree view
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,

pgsql-general by date:

Previous
From: Andres Freund
Date:
Subject: Re: Dealing with latency to replication slave; what to do?
Next
From: Rory Falloon
Date:
Subject: Re: Dealing with latency to replication slave; what to do?