Re: Ascii Elephant for text based protocols - Final

From: "Karsten Hilbert" <Karsten(dot)Hilbert(at)gmx(dot)net>
To:
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Ascii Elephant for text based protocols - Final
Date: 2016-05-17 16:42:32
Message-ID: trinity-18801acd-a5ee-4517-8882-9446199a0d17-1463503352098@3capp-gmx-bs05
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Tue, May 17, 2016 at 8:25 AM, Victor Yegorov <vyegorov(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Guyren Howe 2016-05-17 17:36:03 Re: FIRST_VALUE argument must appear in group by?
Previous Message George Neuner 2016-05-17 16:31:27 Re: PG wire protocol question