Re: [ADMIN] When I executed type cast functions. The postgresnormal concatenation operator query was breaking.

#1

"Saravanakumar Ramasamy" <rsk (AT) zoniac (DOT) com> wrote:

Quote:

Now I am using postgres 9.1.3 version . Before I am used 8.2.22

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

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

I found solution. That solution is 13 implicit type cast. When I
executed type cast functions [concatenations started breaking]

ERROR: operator is not unique: numeric || unknown

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

This was also posted on StackOverflow:

http://stackoverflow.com/questions/1...ation-operator

The accepted solution there was basically to drop the 13 implicit
casts which were added in an attempt to maintain pre-8.3 behavior,
and to change code which counted on the implicit casts which were
eliminated in 8.3.

-Kevin

--
Sent via pgsql-admin mailing list (pgsql-admin (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [ADMIN] When I executed type cast functions. The postgresnormal concatenation operator query was breaking.

mailing.database.pgsql-admin mailing.database.pgsql-admin

Re: [ADMIN] When I executed type cast functions. The postgresnormal concatenation operator query was breaking. - 08-20-2012 , 11:08 AM