Converting a timestamp to a date when it contains nulls.

From: "Michael Richards" <michael(at)fastmail(dot)ca>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Converting a timestamp to a date when it contains nulls.
Date: 2000-07-23 09:14:18
Message-ID: 397AB76A.00010F.68113@frodo.searchcanada.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi.
I'm not sure if the following behaviour is expected or not.

Version info:
psql (PostgreSQL) 7.0.1
4.0-STABLE FreeBSD 4.0-STABLE #0: Tue Apr 25 18:34:52 EDT 2000

I have a table:
create table test (td timestamp);
I add a row:
insert into test values ('now');
I select from it casting td to a date:
select td::date from test;
?column?
------------
2000-07-23
(1 row)

Everything is peachy.

Now I insert a NULL:
insert into test values (NULL);
Everything is no longer peachy.
select td::date from test;
ERROR: Unable to convert null timestamp to date

Shouldn't all casts be able to handle the case where it is NULL?

-Michael

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2000-07-23 17:19:30 Re: Converting a timestamp to a date when it contains nulls.
Previous Message Tom Lane 2000-07-23 05:57:40 Re: Damn bug!