X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id CDEA09F9CC1 for ; Tue, 2 May 2006 15:55:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 01911-07 for ; Tue, 2 May 2006 15:55:01 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 7CFB29FA261 for ; Tue, 2 May 2006 15:55:01 -0300 (ADT) Received: from hotmail.com (bay101-f11.bay101.hotmail.com [64.4.56.21]) by svr4.postgresql.org (Postfix) with ESMTP id 52C765B5A1A for ; Tue, 2 May 2006 18:55:00 +0000 (GMT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 2 May 2006 11:54:57 -0700 Message-ID: Received: from 64.4.56.200 by by101fd.bay101.hotmail.msn.com with HTTP; Tue, 02 May 2006 18:54:55 GMT X-Originating-IP: [85.196.174.134] X-Originating-Email: [pmanchev@hotmail.com] X-Sender: pmanchev@hotmail.com From: "Peter Manchev" To: pgsql-sql@postgresql.org Subject: Compute hash of a table? Date: Tue, 02 May 2006 11:54:55 -0700 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 02 May 2006 18:54:57.0898 (UTC) FILETIME=[E8679CA0:01C66E19] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/31 X-Sequence-Number: 25062 Hi All I need to determine whether the content of a given table has changed from the previous time I've checked it. so, my initial idea is to calculate a hash value of the content of the whole table, may be with custom aggregate function or something. My question is: Is it possible to get the last time(stamp) when the content of a given table in pgsql has changed??? Thanks! Pete