| From: | "Nic Ferrier" <nferrier(at)tapsellferrier(dot)co(dot)uk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Postgres SQL 7.1 a thank you and a possible bug |
| Date: | 2001-02-02 19:32:38 |
| Message-ID: | sa7b0cef.060@tapsellferrier.co.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Clark | 2001-02-02 21:12:22 | Programmer's Guide |
| Previous Message | Stephan Szabo | 2001-02-02 19:14:48 | Re: plpgsql always returning null.. |