AnsweredAssumed Answered

postgresql and implicit int to boolean type casting

Question asked by dkt on May 7, 2011
In code google, there is a project called EVT, alfresco environment validation tool.
http://code.google.com/p/alfresco-environment-validation/

It has one of the checking that implicit Int to Boolean type casting is needed.

I have tried Alfresco 3.4.1 Enterprise, the postgresql failed with the checking:

  Client Encoding       : UTF8 ………………………………….PASS
  Server Encoding       : UTF8 ………………………………….PASS
  Int to Bool Casts     : explicit ………………………………FAIL!!
    Reason              : Implicit casts from int* to bool are not enabled
    Ramification        : Alfresco will not function correctly
    Remedy              : Correct the PostgreSQL implicit type conversion configuration and rerun this test
    For more information: http://www.postgresql.org/docs/8.4/static/typeconv.html

Is the type casting necessary? I can't find any pointers about this one in the internet or in the manual.
Any comment? Thanks.

Outcomes