Re: md5 hash on table row

[Michael Fuhr <mike@xxxxxxxx>]

On Wed, Nov 02, 2005 at 09:35:33AM -0700, Michael Fuhr wrote:
> test=> SELECT id, md5(textin(record_out(foo))) FROM foo;
>  id |               md5                
> ----+----------------------------------
>   1 | b1cbe3d5ed304f31da57b85258f20c8f

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.

-- 
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match