Message-
From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at]
Sent: Friday, February 22, 2013 8:31 AM
To: Schade, Jeffrey; pgsql-general@postgresql.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)
>
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
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
We recently installed the GreenPlum massively Parallel Appliance which
is using Postgres version 8.2.15 and I have been asked to provide a
security report showing all user and group roles and the access they
have to the user data and views. In the Postgres catalog tables I have
located the tables w
