Re: [pgadmin-support] Redefining a column within a view

2013-02-22 Thread Schade, Jeffrey
Schade, Jeffrey Sent: Friday, February 22, 2013 8:09 AM To: pgadmin-support@postgresql.org Subject: [pgadmin-support] Redefining a column within a view We have a table which contains a 3 byte column with datatype CHAR(3) which we want to redefine within the view as a CHAR(1) column and a CHAR(2)

[pgadmin-support] Redefining a column within a view

2013-02-22 Thread Schade, Jeffrey
We have a table which contains a 3 byte column with datatype CHAR(3) which we want to redefine within the view as a CHAR(1) column and a CHAR(2) column. When I code the SUBSTR function the resulting column datatype is TEXT. I would like to see the CHAR datatype, is there anything I can do to set th