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.