Skip to content

Instantly share code, notes, and snippets.

@brito

brito/bar.sql

Created May 23, 2020 02:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save brito/1b64ba2093dc43869bb6f1f6b84d2daf to your computer and use it in GitHub Desktop.
Save brito/1b64ba2093dc43869bb6f1f6b84d2daf to your computer and use it in GitHub Desktop.
Download ZIP
Simple ASCII bar visualization of a single quantity
Raw
bar.sql
/*
Simple ASCII bar visualization of a single quantity
eg */ select * from _bar(53); /*
*/
create function _bar(_quantity int, _glyph text = '■')
returns text as $$
select repeat(_glyph,_quantity/3) || ' ' || _quantity
$$ language sql immutable;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment