combination of 'textcat' and 'interval' in 7.2.

From: Bhuvan A <bhuvansql(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: combination of 'textcat' and 'interval' in 7.2.
Date: 2002-02-20 12:02:07
Message-ID: Pine.LNX.4.20.0202201723150.8841-100000@Larry
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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 <variable> interval(textcat (4, '' hours''));

But now, i do use (in 7.2)
SELECT INTO <variable> 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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Good 2002-02-20 13:11:11 Re: Issues w/ 7.1 to 7.2 upgrade.
Previous Message Christopher Kings-Lynne 2002-02-20 08:59:09 Re: comparision chart