From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: pgsql-admin@postgresql.org
To: rsk@zoniac.com
Cc: 'Gnanakumar' <gnanam@zoniac.com>
Cc: senthil@zoniac.com
Subject: Re: When I executed type cast functions. The postgres normal concatenation operator query was breaking.
Date: Mon, 20 Aug 2012 11:08:44 -0500
Message-ID: <50321ABC0200002500049925@gw.wicourts.gov> (raw)
In-Reply-To: <000c01cd7c4f$f65e7ae0$e31b70a0$@com>
References: <000c01cd7c4f$f65e7ae0$e31b70a0$@com>
"Saravanakumar Ramasamy" <rsk@zoniac.com> wrote:
> 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/12007988/when-i-executed-type-cast-functions-the-postgres-normal-...
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
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: Kevin.Grittner@wicourts.gov, 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: <50321ABC0200002500049925@gw.wicourts.gov>
* 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