From: Saravanakumar Ramasamy <rsk@zoniac.com>
To: pgsql-admin@postgresql.org
Cc: 'Gnanakumar' <gnanam@zoniac.com>
Cc: senthil@zoniac.com
Cc: rsk@zoniac.com
Subject: When I executed type cast functions. The postgres normal concatenation operator query was breaking.
Date: Fri, 17 Aug 2012 13:41:48 +0530
Message-ID: <000c01cd7c4f$f65e7ae0$e31b70a0$@com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: rsk@zoniac.com, gnanam@zoniac.com, senthil@zoniac.com
Subject: Re: When I executed type cast functions. The postgres normal concatenation operator query was breaking.
In-Reply-To: <000c01cd7c4f$f65e7ae0$e31b70a0$@com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox