* Richard Huxton: > I take it SELECT DISTINCT bar... shows the same problem? SELECT bar FROM baz does *not* show the duplicate row. > If so, can you do: > SELECT OID,xmin,cmin,xmax,cmax,bar FROM baz > WHERE bar = <something with duplicates> Even if I force a complete index scan, I get xmin = 1007617 for both rows, the others are zero. The table hasn't got OIDs. -- Florian Weimer <fweimer@xxxxxx> BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99