Heikki Linnakangas wrote:
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?
Hi Heikki
I use pgAdmin3 query tool (the header of columns show the type of each
one), and my application in VFP that access postgres trough pgsql odbc
The same behavior in pgAdmin3 occur in my application.
--
Luiz K. Matsumura
Plan IT Tecnologia Informática Ltda.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
