Not exactly a showstopper, but I noticed this behaviour:
db=# create table f1 (id int, value int);
db=# insert into f1 select 1 as id, null;
INSERT 25456306 1
db=# insert into f1 select distinct 2 as id, null;
ERROR: column "value" is of type integer but expression is of type text
HINT: You will need to rewrite or cast the expression.
db=# insert into f1 select distinct on (id) 2 as id, null;
INSERT 25456307 1
So it seems distinct applied to the second column causes it to lose knowledge
on its type.
Does anybody happen to know why ?
pgsql-general by date
|Next:||From: Stephan Szabo||Date: 2004-08-24 21:26:57|
|Subject: Re: How is this possible? (more on deadlocks)|
|Previous:||From: Doug McNaught||Date: 2004-08-24 21:15:23|
|Subject: Re: Problem to connect to the Windows Port|