Обсуждение: When I executed type cast functions. The postgres normal concatenation operator query was breaking.

Hi All.

Now I am using postgres 9.1.3 version . Before I am used 8.2.22 after I upgraded 9.1.3. Upgraded was successfully completed.

In Postgres 8.2.22

#------------------#

POSTGRES8222=# select TO_NUMBER('12345678',9999999999.99);

 to_number

-----------

  12345678

(1 row)

POSTGRES8222=# select a ||'$'|| b from test;

 ?column?

----------

 1$abcdef

 2$ghijkl

 3$3456

(3 rows)

STATUS : Both queries are executed well.

After upgrade In Postgres 9.1.3

#----------------------------------#

Problem 1 :

===========

beforetypecast=# select TO_NUMBER('12345678',9999999999.99);

ERROR:  function to_number(unknown, numeric) does not exist

LINE 1: select TO_NUMBER('12345678',9999999999.99);

               ^

HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

EXCEPTION

org.postgresql.util.PSQLException: ERROR: function to_number(numeric, numeric) does not exist

Hint: No function matches the given name and argument types. You might need to add explicit type casts.

Position: 150

Problem 2 :

============

beforetypecast=# select a ||'$'|| b from test;

 ?column?

----------

 1$abcdef

 2$ghijkl

 3$3456

(3 rows)

ERROR : No

I found solution. That solution is 13 implicit type cast. When I executed type cast functions. The postgres normal concatenation operator query was breaking. The error are follows

Problem 1 :

============

aftertypecast=# select TO_NUMBER('12345678',9999999999.99);

 to_number

-----------

  12345678

(1 row)

ERROR : No

Problem 2 :

============

aftertypecast=# select a ||'$'|| b from test;

ERROR:  operator is not unique: numeric || unknown

LINE 1: select a ||'$'|| b from test;

                 ^

HINT:  Could not choose a best candidate operator. You might need to add explicit type casts.

********** Error **********

ERROR: operator is not unique: numeric || unknown

SQL state: 42725

Hint: Could not choose a best candidate operator. You might need to add explicit type casts.

Character: 10

With Regards,

Saravanakumar Ramasamy.