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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
