Postgres Pro
Downloads
Home   >   mailing lists

Re: Ascii Elephant for text based protocols - Final - Mailing list pgsql-general

From Bryan Nuse
Subject Re: Ascii Elephant for text based protocols - Final
Date
Msg-id 573B1F9F.908@uga.edu
Whole thread Raw
In response to Re: Ascii Elephant for text based protocols - Final  (Victor Yegorov <vyegorov@gmail.com>)
Responses Re: Ascii Elephant for text based protocols - Final
List pgsql-general
Tree view

On 05/17/2016 08:25 AM, Victor Yegorov wrote:

I had a bit of fun with this SQL version and came up with this query:

WITH src(s) AS (
  VALUES ('729472967293732174412176b12173b17111752171927491b1744171b17411217181417211718141734172b191721191724173b1714171912175b17221b1912174b1412178b121715122a172a1b2317d91a172a17f71b1a1912177')
), str AS (
  SELECT string_agg(repeat(translate(substr(s, p, 1), '123456789ab', '(/>)<+ o_|\'), ('x'||lpad(substr(s, p+1, 1), 8, '0'))::bit(32)::int), '') line
    FROM src, generate_series(1, 182, 2) p
)
SELECT substr(line, p, 21) slon FROM str, generate_series(1, 189, 21) p;



I wonder if --under some fonts especially-- that elephant's eyes look a little... aggressive?
Perhaps the following is too cute, however:

   ____  ______  ___ 
  /    )/      \/   \
 (     / __    _\    )
  \    (/ p)  ( g)   )
   \_  (_  )   \ ) _/
     \  /\_/    \)/  
      \/ <//|  |\\>  
           _|  |     
           \|_/     

-- 
Postdoctoral Researcher
Georgia Cooperative Fish & Wildlife Research Unit
University of Georgia
Athens, GA 30606-2152

pgsql-general by date:

Previous
From: "Charles Clavadetscher"
Date:
Subject: Re: Ascii Elephant for text based protocols - Final function proposal
Next
From: Jan de Visser
Date:
Subject: Re: Ascii Elephant for text based protocols - Final