From: | Aleksander Kmetec <aleksander(dot)kmetec(at)intera(dot)si> |
---|---|
To: | "Nykolyn, Andrew" <andrew(dot)nykolyn(at)ngc(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Cast for text->Integer missing in 8.3.5 |
Date: | 2009-01-13 16:51:32 |
Message-ID: | 496CC694.2000103@intera.si |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Nykolyn, Andrew wrote:
> I am trying to upgrade my Postgres server from 8.2.3 to 8.3.5 and have
> found that the cast text->integer and integer->text are missing. Is
> there a reason why they are not there and how can I get them back. I
> have many stored procedures that rely on those casts
I'm right in the middle of trying to solve the same problem, myself.
I started with this link: http://code.open-bio.org/svnweb/index.cgi/biosql/revision?rev=284
But that wasn't enough. In fact, it broke some things that worked before I added the missing implicit casts. Like this,
for example:
select 123::double precision || 'abc';
ERROR: operator is not unique: double precision || unknown
So I also had to define "||(double precision, text)" and "||(text, double precision)" operators. I'm not sure how much
additional work might be needed, but here's what I have so far for adding backwards compatility for "double precision"
datatype:
CREATE FUNCTION pg_catalog.text(double precision)
RETURNS text STRICT IMMUTABLE
LANGUAGE SQL AS 'SELECT textin(float8out($1));';
CREATE CAST (double precision AS text)
WITH FUNCTION pg_catalog.text(double precision) AS IMPLICIT;
CREATE FUNCTION pg_catalog.compat_textcat(double precision, text)
RETURNS text STRICT IMMUTABLE
LANGUAGE SQL AS 'SELECT textcat(CAST($1 AS TEXT), $2);';
CREATE FUNCTION pg_catalog.compat_textcat(text, double precision)
RETURNS text STRICT IMMUTABLE
LANGUAGE SQL AS 'SELECT textcat($1, CAST($2 AS TEXT));';
CREATE OPERATOR pg_catalog.|| (
PROCEDURE = compat_textcat,
LEFTARG = double precision,
RIGHTARG = text
);
CREATE OPERATOR pg_catalog.|| (
PROCEDURE = compat_textcat,
LEFTARG = text,
RIGHTARG = double precision
);
Regards,
Aleksander
From | Date | Subject | |
---|---|---|---|
Next Message | Sam Mason | 2009-01-13 16:58:08 | Re: Trying to create implicit casts to text in PG 8.3 |
Previous Message | Aleksander Kmetec | 2009-01-13 16:43:52 | Re: Trying to create implicit casts to text in PG 8.3 |