Luiz K. Matsumura wrote:
> When we do:
>
> SELECT * from view1;
> OR
> SELECT id,col1,type1,type2 FROM view1;
>
> column type1 return as bpchar
>
>
> But if we do:
> SELECT type1 FROM view1;
> or
> SELECT id,col1,type2,type1 FROM view1;
>
> Now, type1 return as character(3) as expected.
I can't reproduce this. View1.type1 has has type char(3) as expected in
both cases, as witnessed by "CREATE VIEW f AS SELECT */type1 FROM
view1"; \d f". How did you determine the data types?
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com