Thread

1. Converting a timestamp to a date when it contains nulls.

   Michael Richards <michael@fastmail.ca> — 2000-07-23T09:14:18Z

   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

2. Re: Converting a timestamp to a date when it contains nulls.

   Tom Lane <tgl@sss.pgh.pa.us> — 2000-07-23T17:19:30Z

   "Michael Richards" <michael@fastmail.ca> writes:
   > Shouldn't all casts be able to handle the case where it is NULL?
   
   Yup, it's a bug.  It's fixed in current sources.
   
   			regards, tom lane