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

From Karsten Hilbert
Subject Re: Ascii Elephant for text based protocols - Final
Date
Msg-id trinity-18801acd-a5ee-4517-8882-9446199a0d17-1463503352098@3capp-gmx-bs05
Whole thread Raw
In response to Re: Ascii Elephant for text based protocols - Final  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
> On Tue, May 17, 2016 at 8:25 AM, Victor Yegorov <vyegorov@gmail.com> 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 would nominate this to be called

 select pg_logo_obfuscated();

Karsten


pgsql-general by date:

Previous
From: George Neuner
Date:
Subject: Re: PG wire protocol question
Next
From: Guyren Howe
Date:
Subject: Re: FIRST_VALUE argument must appear in group by?