|
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. |
