Postgresql - invalid WHERE clause for BOOL columns generated (adapter fix)

[T E Schmitz]

Hello,

I just hit upon a problem with Postgresql columns of type bool.

Torque generates invalid SQL for bool comparisons:
generates   : WHERE xyz=0
needs to be : WHERE xyz=FALSE (or WHERE xyz='0')
The fault is in the adapter. I amended the adapter as follows and it 
works fine now:
public String getBooleanString(Boolean b)
{
  //return (b == null) ? "0" : (Boolean.TRUE.equals(b) ? "1" : "0");
  return (b == null) ? "NULL" : (Boolean.TRUE.equals(b) ? "TRUE" : 
"FALSE");
}

--

Regards,

Tarlika Elisabeth Schmitz

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]