Re: BUG #3598: Strange behaviour of character columns in select with views - Mailing list pgsql-bugs

From Luiz K. Matsumura
Subject Re: BUG #3598: Strange behaviour of character columns in select with views
Date
Msg-id 46DDA2E8.3020306@planit.com.br
Whole thread Raw
In response to Re: BUG #3598: Strange behaviour of character columns in select with views  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
List pgsql-bugs
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.

pgsql-bugs by date:

Previous
From: "Luiz K. Matsumura"
Date:
Subject: Re: BUG #3597: CREATE OR REPLACE VIEW
Next
From: Jukka Holappa
Date:
Subject: Re: BUG #3595: Segmentation fault with a simple select query