Re: md5 hash on table row - Mailing list pgsql-general

From Michael Fuhr
Subject Re: md5 hash on table row
Date
Msg-id 20051102173325.GA12451@winnie.fuhr.org
Whole thread Raw
In response to Re: md5 hash on table row  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: md5 hash on table row  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: md5 hash on table row  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Wed, Nov 02, 2005 at 06:07:45PM +0100, A. Kretschmer wrote:
> am  02.11.2005, um  9:35:33 -0700 mailte Michael Fuhr folgendes:
> > test=> SELECT id, md5(textin(record_out(foo))) FROM foo;
>
> is 'record_out()' new in 8.1?

The signature has changed over time:

7.3  record_out(record)
7.4  record_out(record)
8.0  record_out(record,oid)
8.1  record_out(record)

As I already discovered and as Tom pointed out, the cast from foo
to record works only in 8.1.  In 8.0 you can use row(foo), but that
adds even more decoration to the output.

--
Michael Fuhr

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: md5 hash on table row
Next
From: Tony Caduto
Date:
Subject: Re: Postgres + CentOS