| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Victor Yegorov <vyegorov(at)gmail(dot)com> |
| Cc: | Charles Clavadetscher <clavadetscher(at)swisspug(dot)org>, "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 14:41:37 |
| Message-ID: | CAB7nPqRhU6S6xpc_NpMUR+BV-E3VbikDga4m0c6Ve9PWAseV_A@mail.gmail.com |
| 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;
You just made my day.
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Willy-Bas Loos | 2016-05-17 16:10:29 | edit wiki |
| Previous Message | Edson Richter | 2016-05-17 14:30:12 | Re: Columnar store as default for PostgreSQL 10? |