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)

Re: [GENERAL] Ascii Elephant for text based protocols

2016-05-16 Thread Charles Clavadetscher
I think I found a better representation for the end of the trunk: ++ | __ ___| | /)/ \/ \ | | ( / ___\) | | \(/ o) ( o) ) | | \_ (_ ) \ ) _/ | | \ /\_/\)/ | | \/ | || |

Re: [GENERAL] Ascii Elephant for text based protocols

2016-05-15 Thread Charles Clavadetscher
Hello Melvin Thank you for your code. With the current design (not yet necessarily the final one): 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

2016-05-15 Thread Melvin Davidson
On Sun, May 15, 2016 at 11:47 PM, Charles Clavadetscher < clavadetsc...@swisspug.org> wrote: > Hello Tom > > Thanks for your feedback. > > On 05/16/2016 05:31 AM, Tom Lane wrote: > >> Charles Clavadetscher writes: >> >>> On 05/16/2016 02:51 AM, dandl wrote: >>> * the trunk is (how shall I pu

Re: [GENERAL] Ascii Elephant for text based protocols

2016-05-15 Thread Charles Clavadetscher
Hello Tom Thanks for your feedback. On 05/16/2016 05:31 AM, Tom Lane wrote: Charles Clavadetscher writes: On 05/16/2016 02:51 AM, dandl wrote: * the trunk is (how shall I put this?) somewhat phallic. Mmh... This could apply to any elephant picture. I don't think that this needs a change,

Re: [GENERAL] Ascii Elephant for text based protocols

2016-05-15 Thread Tom Lane
Charles Clavadetscher writes: > On 05/16/2016 02:51 AM, dandl wrote: >> * the trunk is (how shall I put this?) somewhat phallic. > Mmh... This could apply to any elephant picture. I don't think that this > needs a change, but let's see if there are more feedbacks. I'd say the problem is at the

Re: [GENERAL] Ascii Elephant for text based protocols

2016-05-15 Thread Charles Clavadetscher
Of Peter J. Holzer Sent: Monday, 16 May 2016 9:11 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Ascii Elephant for text based protocols On 2016-05-15 14:02:56 +0200, Cha

Re: [GENERAL] Ascii Elephant for text based protocols

2016-05-15 Thread dandl
neral@postgresql.org > Subject: Re: [GENERAL] Ascii Elephant for text based protocols > > On 2016-05-15 14:02:56 +0200, Charles Clavadetscher wrote: > > ++ > > | __ ___| > > | /)/ \/ \ | > &

Re: [GENERAL] Ascii Elephant for text based protocols

2016-05-15 Thread Michael Paquier
On Sun, May 15, 2016 at 9:02 PM, Charles Clavadetscher wrote: > If the community finds the draft ok and the idea meaningful, it could even > be added to the list of available logos? FWIW, I am a fan of ASCII art. > ++ > | __ ___| > | /)/ \/ \

Re: [GENERAL] Ascii Elephant for text based protocols

2016-05-15 Thread Peter J. Holzer
On 2016-05-15 14:02:56 +0200, Charles Clavadetscher wrote: > ++ > | __ ___| > | /)/ \/ \ | > | ( / ___\) | > | \(/ o) ( o) ) | > | \_ (_ ) \ ) / | > | \ /\_/\)_/| > | \/ //| |\\ | > |

[GENERAL] Ascii Elephant for text based protocols

2016-05-15 Thread Charles Clavadetscher
Hello We have a long week-end this days and so I tried to create an elephant using ASCII characters that could be used for mail signatures or wherever you prefer not to use a graphical interface. I tried to find something ready on the internet but was unable to spot anything useful and small