14.16. Color Functions

bar(x, width) → varchar

Renders a single bar in an ANSI bar chart using a default low_color of red and a high_color of green. For example, if x of 25% and width of 40 are passed to this function. A 10-character red bar will be drawn followed by 30 spaces to create a bar of 40 characters.

bar(x, width, low_color, high_color) → varchar

Renders a single line in an ANSI bar chart of the specified width. The parameter x is a double value between [0,1]. Values of x that fall outside the range [0,1] will be truncated to either a 0 or a 1 value. The low_color and high_color capture the color to use for either end of the horizontal bar chart. For example, if x is 0.5, width is 80, low_color is 0xFF0000, and high_color is 0x00FF00 this function will return a 40 character bar that varies from red (0xFF0000) and yellow (0xFFFF00) and the remainder of the 80 character bar will be padded with spaces.

color(string) → color

Returns a color capturing a decoded RGB value from a 4-character string of the format “#000”. The input string should be varchar containing a CSS-style short rgb string or one of black, red, green, yellow, blue, magenta, cyan, white.

color(x, low, high, low_color, high_color) → color

Returns a color interpolated between low_color and high_color using the double parameters x, low, and high to calculate a fraction which is then passed to the color(fraction, low_color, high_color) function shown below. If x falls outside the range defined by low and high it’s value will be truncated to fit within this range.

color(x, low_color, high_color) → color

Returns a color interpolated between low_color and high_color according to the double argument x between 0 and 1.0. The parameter x is a double value between [0,1]. Values of x that fall outside the range [0,1] will be truncated to either a 0 or a 1 value.

render(x, color) → varchar

Renders value x using the specific color using ANSI color codes. x can be either a double, bigint, or varchar.

render(b) → varchar

Accepts boolean value b and renders a green true or a red false using ANSI color codes.

rgb(red, green, blue) → color

Returns a color value capturing the RGB value of three component color values supplied as int parameters ranging from 0 to 255: red, green, blue.