Rudder

The SQL query to test for fileFormat=1 is:

SELECT * FROM eventlog WHERE 
  xmlexists('/entry/*[@fileFormat=1]'PASSING BY REF data) OR 
  xmlexists('/entry/addPending'PASSING BY REF data)
  LIMIT 1;

The SQL insert to do if the previous select return a result:

INSERT INTO migrationeventlog(detectiontime, detectedfileformat)
VALUES ('NOW', 1);

Of course, "NOW" should be date like "2012-02-13 02:19:09.89+01"

Bump

I didn't try to do it in one run, but the first part of the query, to count fileFormat 1 is :

select count(*) from (
select xpath('/entry/*[@fileFormat=1]',data) AS x
from eventlog) as Y
where array_upper(x, 1) > 0;

the second is :

select count(*) from (
select xpath('/entry/addPending',data) AS x
from eventlog) as Y
where array_upper(x, 1) > 0;

If any of them return a number greater than 0, then the update should be done