From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Jon Lapham <lapham(at)jandr(dot)org>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: md5 hash on table row |
Date: | 2005-11-02 17:26:14 |
Message-ID: | 20051102172614.GA12407@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Nov 02, 2005 at 12:18:15PM -0500, Tom Lane wrote:
> Michael Fuhr <mike(at)fuhr(dot)org> writes:
> > I just noticed that record_out(foo) works only in 8.1. When I have
> > more time I'll see if it's possible in earlier versions.
>
> Probably not :-(
This works in 8.0.4, although it gives even more decoration:
test=> SELECT id, textin(record_out(row(foo), tableoid)) FROM foo;
id | textin
----+-----------------------------------------------------------------------
1 | ("(1,123,""this is a test"",2005-11-02,t,""\\\\000\\\\001\\\\002"")")
(1 row)
test=> SELECT id, md5(textin(record_out(row(foo), tableoid))) FROM foo;
id | md5
----+----------------------------------
1 | 3e66ee01b83eeb1a2444df326b75ffe0
(1 row)
--
Michael Fuhr
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2005-11-02 17:33:25 | Re: md5 hash on table row |
Previous Message | Michael Fuhr | 2005-11-02 17:23:20 | Re: md5 hash on table row |