On Thu, 2009-02-12 at 14:21 -0800, Adrian Klaver wrote: > On Thursday 12 February 2009 11:37:37 am Paolo Saudin wrote: >
> > SELECT fulldate,sensor > FROM (SELECT fulldate,sensor,count(sensor) > FROM (SELECT 1 AS station, fulldate, meanvalue AS sensor FROM > table1 > UNION > SELECT 2, fulldate, meanvalue FROM table2 ORDER BY > fulldate,sensor) AS x > GROUP BY fulldate,sensor) AS y > WHERE y.count>1; > > > and got- > > fulldate | sensor > ---------------------+-------- > 2009-01-01 00:00:00 | 12.3 > 2009-01-01 02:00:00 | 82.1 > 2009-01-01 03:00:00 | 79.8 > 2009-01-01 04:00:00 | 77.2 You might want to do a UNION with all your tables to add a field to identify the table, and use min() and max() to show the offending tables. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
