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,'+------------------------+'), ( 2,'| ____ ______ ___ |'), ( 3,'| / )/ \/ \ |'), ( 4,'| ( / __ _\ ) |'), ( 5,'| \ (/ o) ( o) ) |'), ( 6,'| \_ (_ ) \ ) _/ |'), ( 7,'| \ /\_/ \)/ |'), ( 8,'| \/ <//| |\\> |'), ( 9,'| | | |'), (10,'| |/\| |'), (11,'| |'), (12,'| PostgreSQL 1996-2016 |'), (13,'| 20 Years of success |'), (14,'+------------------------+'); SELECT row_dat FROM elephant ORDER BY row_num; Bye Charles On 05/16/2016 05:56 AM, Melvin Davidson wrote:
To all, thanks for the concept. The following based on original design submission, might help in tweaking: 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,'+------------------------+'), ( 2,'| ____ ______ ___ |'), ( 3,'| / )/ \/ \ |'), ( 4,'| ( / __ _\ ) |'), ( 5,'| \ (/ o) ( o) ) |'), ( 6,'| \_ (_ ) \ ) / |'), ( 7,'| \ /\_/ \)_/ |'), ( 8,'| \/ //| |\\ |'), ( 9,'| v | | v |'), (10,'| \__/ |'), (11,'| |'), (12,'| PostgreSQL 1996-2016 |'), (13,'| 20 Years of success |'), (14,'+------------------------+'); SELECT row_dat FROM elephant ORDER BY row_num; -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
-- Swiss PostgreSQL Users Group c/o Charles Clavadetscher Motorenstrasse 18 CH - 8005 Zürich http://www.swisspug.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
