First of all 7.1 is great! I'm using beta4 and it seems to be working very well. Thank's particularly for the SQL92 join syntax (though union joins would be usefull). I have a problem though and I'm not sure if it's a bug or not so I thought I'd discuss it here first. The synopsis of the problem is that date columns don't seem to be working as dates when they're selected through a union view. For example create table A ( id INTEGER, date DATE); insert into table A values (1,'1 dec 1999'); create table B ( id INTEGER, somedate DATE); insert into table B values (2,'3 jan 2000'); create view C as select id,date from A union select id,somedate from B; select * from C where date<'1 jan 2000'; > id date >---------------------------- > 1 '1999-12-01' > 2 '2000-01-03' select * from C where date<'1 jan 2001'; > id date >---------------------------- > 1 '1999-12-01' > 2 '2000-01-03' Which seems strange especially as this: \d C produces the following: > Attribute | Type | Modifier > -----------+------+---------- > id | integer | > date | date | I've tried casting the date in various ways but none of it works. Is this a bug or am I doing something gloriously stupid? Nic Ferrier