Skip site navigation (1) Skip section navigation (2)

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

From: "Luiz K(dot) Matsumura" <luiz(at)planit(dot)com(dot)br>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3598: Strange behaviour of character columns in select with views
Date: 2007-09-04 18:24:40
Message-ID: 46DDA2E8.3020306@planit.com.br (view raw or flat)
Thread:
Lists: 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.


In response to

pgsql-bugs by date

Next:From: Hiroshi SaitoDate: 2007-09-05 01:52:36
Subject: Re: BUG #3600: ODBC Driver not working with BIGINT
Previous:From: Luiz K. MatsumuraDate: 2007-09-04 18:09:16
Subject: Re: BUG #3597: CREATE OR REPLACE VIEW

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group