in reply to How to match elements of array

Can make this simpler... I have two alternatives:

1) Create a unique index on file name column, and let the insert fail if it's a duplication.

2) Use SQL in clause, so use one query, you can figure out whether any of those four names exist.

Peter (Guo) Pei