Re: BUG #3598: Strange behaviour of character columns in select with views

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.