X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D769655112 for ; Fri, 4 Mar 2005 20:59:10 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 88771-05 for ; Fri, 4 Mar 2005 20:59:02 +0000 (GMT) Received: from mail.libertyrms.com (unknown [207.219.45.62]) by svr1.postgresql.org (Postfix) with ESMTP id 85A9F54DAC for ; Fri, 4 Mar 2005 20:59:01 +0000 (GMT) Received: from dba4.int.libertyrms.com ([10.1.3.13] ident=ahammond) by mail.libertyrms.com with esmtp (Exim 4.22) id 1D7Jt0-0000K7-PD for pgsql-sql@postgresql.org; Fri, 04 Mar 2005 15:59:02 -0500 Message-ID: <4228CC16.7020900@ca.afilias.info> Date: Fri, 04 Mar 2005 15:59:02 -0500 From: Andrew Hammond Organization: Afilias Canada Corp. User-Agent: Mozilla Thunderbird 0.9 (X11/20041124) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: date - date returns integer? X-Enigmail-Version: 0.89.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-SA-Exim-Mail-From: ahammond@ca.afilias.info X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.574 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, INFO_TLD, UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200503/62 X-Sequence-Number: 20541 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Should date - date return type integer, not interval? /* ahammond@test:5432/test =# */ SELECT ('2005-03-04'::timestamp - '2005-01-01'::date)::interval; ~ interval - ---------- ~ 62 days (1 row) /* ahammond@test:5432/test =# */ SELECT ('2005-03-04'::date - '2005-01-01'::date)::interval; ERROR: cannot cast type integer to interval - -- Andrew Hammond 416-673-4138 ahammond@ca.afilias.info Database Administrator, Afilias Canada Corp. CB83 2838 4B67 D40F D086 3568 81FC E7E5 27AF 4A9A -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) iD8DBQFCKMwVgfzn5SevSpoRAlxAAJ9iPVf2yTNt11JBGc6Hun2s23+/MwCfYRwL SzElfOrlIskOTAZucUdCeUE= =jgOp -----END PGP SIGNATURE-----