Re: md5 hash on table row

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