Color functions#
- bar(x, width) varchar #
Renders a single bar in an ANSI bar chart using a default
low_color
of red and ahigh_color
of green. For example, ifx
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 parameterx
is a double value between 0 and 1. Values ofx
that fall outside the range [0, 1] will be truncated to either a 0 or a 1 value. Thelow_color
andhigh_color
capture the color to use for either end of the horizontal bar chart. For example, ifx
is 0.5,width
is 80,low_color
is 0xFF0000, andhigh_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
andhigh_color
using the double parametersx
,low
, andhigh
to calculate a fraction which is then passed to thecolor(fraction, low_color, high_color)
function shown below. Ifx
falls outside the range defined bylow
andhigh
its value is truncated to fit within this range.
- color(x, low_color, high_color) color
Returns a color interpolated between
low_color
andhigh_color
according to the double argumentx
between 0 and 1. The parameterx
is a double value between 0 and 1. Values ofx
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
.