Re: md5 hash on table row

On Wed, Nov 02, 2005 at 11:38:46AM -0200, Jon Lapham wrote:
> I would love something like this:
> select id, md5(*) from mytable;

Is it acceptable to have some decoration around the data being
hashed? If so then this example might be useful:

test=> SELECT * FROM foo;
id | integer | text | date | boolean | bytea
----+---------+----------------+------------+---------+--------------
1 | 123 | this is a test | 2005-11-02 | t | \000\001\002
(1 row)

test=> SELECT id, foo FROM foo;
id | foo
----+---------------------------------------------------------
1 | (1,123,"this is a test",2005-11-02,t,"\\000\\001\\002")
(1 row)

test=> SELECT id, md5(textin(record_out(foo))) FROM foo;
id | md5
----+----------------------------------
1 | b1cbe3d5ed304f31da57b85258f20c8f
(1 row)

--
Michael Fuhr