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
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 |