From: | "Schade, Jeffrey" <JSchade(at)iso(dot)com> |
---|---|
To: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Redefining a column within a view |
Date: | 2013-02-22 13:34:52 |
Message-ID: | DB138660B6B01D458B16F9205C0C263427CFC11A@ISOEMAILP3.iso.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Good Morning Laurenz,
That worked perfectly.
Thank You
Jeff
_________________________________________
Jeffrey Schade
Systems Consultant, Technology Engineering
ISO
545 Washington Boulevard
Jersey City, NJ 07310
Voice: (201) 469-3738
FAX: (201) 748-1500
jschade(at)iso(dot)com
-----Original Message-----
From: Albe Laurenz [mailto:laurenz(dot)albe(at)wien(dot)gv(dot)at]
Sent: Friday, February 22, 2013 8:31 AM
To: Schade, Jeffrey; pgsql-general(at)postgresql(dot)org
Subject: RE: Redefining a column within a view
Jeffrey Schade wrote:
> 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 the proper datatype. The sample view is below:
>
> CREATE OR REPLACE VIEW schema.jeff_view AS SELECT col1 ,
> col2,
> Substr(col3,1,1) as col3_part1,
> Substr(col3,2) as col3_part2,
> col4
> FROM schema.jeff_table;
Try:
[...]
Substr(col3,1,1)::char(1) as col3_part1,
Substr(col3,2)::char(2) as col3_part2,
[...]
Yours,
Laurenz Albe
This email is intended for the recipient only. If you are not the intended recipient please disregard, and do not use the information for any purpose.
From | Date | Subject | |
---|---|---|---|
Next Message | Stefan Andreatta | 2013-02-22 13:57:28 | autoanalyze criteria |
Previous Message | Albe Laurenz | 2013-02-22 13:31:15 | Re: Redefining a column within a view |