Hi Denny,there is a statement for unique values for MySQL and PG. If, for some reason its not doing what its intended to, let us investigate and fix.
thanks for reporting this, Syed Chan, Denny (NIH/NCI) [C] wrote:
Hi,I was looking at the _toSQL method in the FilterList.pm module. The routine removes duplicates values from the IN list for oracle database. Why not for the others?I use postgresql database. The duplicates really slow down the query performance.Thanks, Denny
