Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eBCErIm79774 for ; Tue, 12 Dec 2000 09:53:18 -0500 (EST) (envelope-from pgsql-bugs-owner@postgresql.org) Received: from thor.tht.net (thor.tht.net [209.47.145.4]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eB807FP12844; Thu, 7 Dec 2000 19:07:15 -0500 (EST) (envelope-from edmar@brasmap.com) Received: from gw.acate.com.br ([200.215.17.89]) by thor.tht.net (8.9.3/8.9.3) with ESMTP id TAA97554; Thu, 7 Dec 2000 19:07:31 GMT (envelope-from edmar@brasmap.com) Received: from ana ([192.168.1.13]) by gw.acate.com.br (8.9.3/8.9.3) with SMTP id VAA06728; Thu, 7 Dec 2000 21:07:28 -0200 From: "Edmar Wiggers" To: , Subject: Unable to convert null timestamp to date. Bug? Date: Thu, 7 Dec 2000 21:08:09 -0200 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200012/67 X-Sequence-Number: 256 Strange, this works: select * from users where last_visit > now() + 7; -- last_visit is nullable, of type timestamp But this doesn't select * from users where last_visit + 7 > now(); ERROR: Unable to convert null timestamp to date -- yes, there are users where last_visit IS NULL BTW, this works too: select null+1; -- obviously returns NULL System is FreeBSD 4.1, PgSQL 7.0.2 Anyone got a clue? Yours sincerely, Edmar Wiggers BRASMAP Information Systems +55 48 9960 2752