Re: Built-in binning functions - Mailing list pgsql-hackers

From David G Johnston
Subject Re: Built-in binning functions
Date
Msg-id 1409526785687-5817097.post@n5.nabble.com
Whole thread Raw
In response to Re: Built-in binning functions  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Built-in binning functions
List pgsql-hackers
Simon Riggs wrote
> width_bucket() seems to refer to an equal-width binning process. The
> function being discussed here is a generic mechanism, the boundaries
> of which could have been decided using equal-frequency or other
> mechanisms. Using the word "width" in those contexts could be
> confusing.
> 
> Given width_bucket() is already in use for SQL Standard function, I
> agree it would be confusing to have same name for different parameter
> profiles.

literal_bucket(float8, float8[])

Since "bucket" is the 'verb' here (in this specific case meaning "lookup the
supplied value in the supplied bucket definition") and "width" is a modifier
(the bucket specification describes an equal-width structure) I suggest
"literal_bucket(val, array[])" such that the bucket is still the verb but
now the modifier describes a structure that is literally provided.

David J.





--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Built-in-binning-functions-tp5807266p5817097.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.



pgsql-hackers by date:

Previous
From: Petr Jelinek
Date:
Subject: Re: Built-in binning functions
Next
From: Tom Lane
Date:
Subject: Re: Built-in binning functions