Re: [GENERAL] Ascii Elephant for text based protocols - Final

2016-05-17 Thread Karsten Hilbert
> On Tue, May 17, 2016 at 8: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 > > ('729472967293732174412176b12173b17111752171927491b1744171b17411217181417211718141734172b191721191724173b1714171912175b17221b

Re: [GENERAL] Ascii Elephant for text based protocols - Final

2016-05-17 Thread Michael Paquier
On Tue, May 17, 2016 at 8: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 > ('729472967293732174412176b12173b17111752171927491b1744171b17411217181417211718141734172b191721191724173b1714171912175b17221b1912174b1412

Re: [GENERAL] Ascii Elephant for text based protocols - Final

2016-05-17 Thread Jan de Visser
On Tuesday, May 17, 2016 9:41:51 AM EDT Bryan Nuse wrote: > 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 > > > > ('729472967293732174412176b12173b17111752171927491b1744171b1741121

Re: [GENERAL] Ascii Elephant for text based protocols - Final

2016-05-17 Thread Bryan Nuse
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 ('729472967293732174412176b12173b17111752171927491b1744171b17411217181417211718141734172b191721191724173b1714171912175b17221b1912174b1412178b121715122a

Re: [GENERAL] Ascii Elephant for text based protocols - Final function proposal

2016-05-17 Thread Charles Clavadetscher
Mai 2016 09:23 > > To: pgsql-general@postgresql.org > > Subject: Re: [GENERAL] Ascii Elephant for text based protocols - Final > > > > On Tue, May 17, 2016 at 06:58:14AM +0200, Charles Clavadetscher wrote: > > > > > A question to the naming. I find pg_logo

Re: [GENERAL] Ascii Elephant for text based protocols - Final function proposal

2016-05-17 Thread Charles Clavadetscher
Hello all > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Karsten Hilbert > Sent: Dienstag, 17. Mai 2016 09:23 > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Ascii Elephant for te

Re: [GENERAL] Ascii Elephant for text based protocols - Final

2016-05-17 Thread Victor Yegorov
2016-05-16 14:47 GMT+03:00 Charles Clavadetscher : > SQL version by Melvin Davidson: > > CREATE TABLE elephant > (row_num integer NOT NULL, > row_dat varchar(30) NOT NULL, > CONSTRAINT elephant_pk PRIMARY KEY (row_num) > ); > > INSERT INTO elephant > (row_num, row_dat) > VALUES > ( 1,'+-

Re: [GENERAL] Ascii Elephant for text based protocols - Final

2016-05-17 Thread Karsten Hilbert
On Tue, May 17, 2016 at 06:58:14AM +0200, Charles Clavadetscher wrote: > A question to the naming. I find pg_logo() also a good name, but is the > prefix pg_* not reserved for system functions? Of course I could use the > name I want, but was wondering if there is a policy or a best practice in >

Re: [GENERAL] Ascii Elephant for text based protocols - Final

2016-05-16 Thread Charles Clavadetscher
Hello On 05/16/2016 10:50 PM, Michael Paquier wrote: On Tue, May 17, 2016 at 5:13 AM, Karsten Hilbert wrote: select pg_logo(); seems like a good idea to me :-) If you propose a patch with a function that returns a setof text, I am sure it would get some attention. Though I think th

Re: [GENERAL] Ascii Elephant for text based protocols - Final

2016-05-16 Thread Michael Paquier
On Tue, May 17, 2016 at 5:13 AM, Karsten Hilbert wrote: > select pg_logo(); > > seems like a good idea to me :-) If you propose a patch with a function that returns a setof text, I am sure it would get some attention. Though I think that you should remove the mention of the 20th anniversa

Re: [GENERAL] Ascii Elephant for text based protocols - Final

2016-05-16 Thread Karsten Hilbert
select pg_logo(); seems like a good idea to me :-) Karsten > SQL version by Melvin Davidson: > > CREATE TABLE elephant > (row_num integer NOT NULL, > row_dat varchar(30) NOT NULL, > CONSTRAINT elephant_pk PRIMARY KEY (row_num) > ); > > INSERT INTO elephant > (row_num, row_dat) > VALU

Re: [GENERAL] Ascii Elephant for text based protocols - Final

2016-05-16 Thread Oleg Bartunov
On Mon, May 16, 2016 at 2:47 PM, Charles Clavadetscher wrote: > SELECT row_dat FROM elephant ORDER BY row_num; Very good ! Thanks ! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Ascii Elephant for text based protocols - Final

2016-05-16 Thread Charles Clavadetscher
Hi all OK. I must come to an end with this task. This is what I find a decent final version and I plan to use it in my SwissPUG signature until the end of the year. ++ | __ ___| | /)/ \/ \ | | ( / ___\) | | \(/ o) ( o)