am Wed, dem 02.04.2008, um 11:56:38 +0800 mailte Michael Enke folgendes: > Hi all, > I need to know if multiple tables have (may have most probably) identical > content. > Since I want a fast solution (which means not comparing tables row by row), > I thought it would be a good idea to have an sql function operating on a > table or view > similar to md5sum on a file and only compare the generated hashes. > I did not find such a function in the documentation. > > Is such a function already available? No. > If not, does it make no sense to use such an approach? I think, no, because there is no order in the tables and there are maybe dead tuples (MVCC) -> different md5-sums for the data files. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
