Received: from Donald.bks ([203.145.133.13]) by postgresql.org (8.11.6/8.11.4) with ESMTP id g1KC7AF99064 for ; Wed, 20 Feb 2002 07:07:11 -0500 (EST) (envelope-from bhuvansql@yahoo.com) Received: from Larry.bks (root@Larry. [200.2.1.10]) by Donald.bks (8.11.6/8.11.2) with ESMTP id g1KC79q22018 for ; Wed, 20 Feb 2002 17:38:06 +0530 Received: from localhost (bhuvan@localhost) by Larry.bks (8.9.3/8.8.5) with ESMTP id RAA11346 for ; Wed, 20 Feb 2002 17:32:07 +0530 X-Authentication-Warning: Larry.bks: bhuvan owned process doing -bs Date: Wed, 20 Feb 2002 17:32:07 +0530 (IST) From: Bhuvan A X-Sender: bhuvan@Larry To: pgsql-sql@postgresql.org Subject: combination of 'textcat' and 'interval' in 7.2. Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200202/252 X-Sequence-Number: 6676 hi, just a day back, i did upgrade to 7.2(from 7.1.2). In my plpgsql functions, i did use(in 7.1.2) SELECT INTO interval(textcat (4, '' hours'')); But now, i do use (in 7.2) SELECT INTO cast (textcat (4, '' hours'') as interval); and it works. is this a permanent fix? will it work in earlier and future releases? Would like to get some links on migration of plpgsql functions from 7.1.x to 7.2? Regards, Bhuvaneswar.