Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1G0XFE55949 for ; Fri, 15 Feb 2002 19:33:15 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g1G0XGf17023; Fri, 15 Feb 2002 19:33:17 -0500 (EST) To: "Josh Berkus" cc: pgsql-sql@postgresql.org Subject: Re: No Interval Conversion Function in 7.2?!!? In-reply-to: References: Comments: In-reply-to "Josh Berkus" message dated "Fri, 15 Feb 2002 16:20:43 -0800" Date: Fri, 15 Feb 2002 19:33:16 -0500 Message-ID: <17020.1013819596@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200202/192 X-Sequence-Number: 6618 "Josh Berkus" writes: > Please help! I just upgraded a production database to PostgreSQL 7.2, > and discovered that INTERVAL() is no longer a function. What replaced > it? How can I convert VARCHAR to Interval? It's still there, but INTERVAL is a reserved word these days. "INTERVAL"(varcharvalue) varcharvalue::interval CAST(varcharvalue AS interval) should all give the same results. Only the last of these is actually standard. regards, tom lane