On 20/05/2014 11:39, Khangelani Gama wrote:
Sorry
I found the problem, it’s data problem in another database, it’s trying
to convert numeric null but of which it’s not a null data, it’s a blank
data.
Hi there,
I'm glad you were able to find the solution to your problem. I have to
say,
Hi
The follow query below works in one database but not on another database.
The databases are similar but independent of each other. From the previous
post I found that: *This is fixed by casting the first argument to **text*
*:,* but I can’t see which COALESCE to fix out the several COALESCE
Sorry
I found the problem, it’s data problem in another database, it’s trying to
convert numeric null but of which it’s not a null data, it’s a blank data.
*From:* Khangelani Gama [mailto:kg...@argility.com]
*Sent:* Tuesday, May 20, 2014 12:24 PM
*To:* pgsql-general@postgresql.org
*Subject:*