Dear WO-dev gurus,
I am running into a problem and couldn't find any mention in the list archive or google.
I just upgraded the database from MSSQL 7 to Postgresql 8.1.3. My WO app works fine except the following problem.
Whenever I have a fetch with an EOQualifier like this:
EOQualifier.qualifierWithQualifierFormat("category_sortName caseInsensitiveLike '[!-l]*'", null);
I get an empty result set. If I changed [!-l]* to let's say a*, I would get results.
My question is, how do you use bracket _expression_ with Postgresql in WO 5.2? If it is not supported, is there an efficient way to achieve the same thing?
Thank you very much for any insight you may have. I apologize in advance if this is a stupid question. :p
sincerely,
Nick Yang |