Re: [GENERAL] md5 hash on table row

2005-11-02 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > On Wed, Nov 02, 2005 at 06:07:45PM +0100, A. Kretschmer wrote: >> 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) BTW, the a

Re: [GENERAL] md5 hash on table row

2005-11-02 Thread Bruce Momjian
Michael Fuhr wrote: > 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: >

Re: [GENERAL] md5 hash on table row

2005-11-02 Thread Michael Fuhr
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 recor

Re: [GENERAL] md5 hash on table row

2005-11-02 Thread Michael Fuhr
On Wed, Nov 02, 2005 at 12:18:15PM -0500, Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> 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 eve

Re: [GENERAL] md5 hash on table row

2005-11-02 Thread Michael Fuhr
On Wed, Nov 02, 2005 at 02:49:57PM -0200, Jon Lapham wrote: > Michael Fuhr wrote: > >test=> SELECT id, foo FROM foo; > > id | foo > >+- > > 1 | (1,123,"this is a test",2005-11-02,t,"\\0

Re: [GENERAL] md5 hash on table row

2005-11-02 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> 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 :-( 2005-05-04 20:19 tgl * src/backend/parser/parse_coerce.c: Allow implicit cast from any named

Re: [GENERAL] md5 hash on table row

2005-11-02 Thread A. Kretschmer
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? Regards, Andreas -- Andreas Kretschmer(Kontakt: siehe Header) Heynitz: 035242/47212, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://ww

Re: [GENERAL] md5 hash on table row

2005-11-02 Thread Michael Fuhr
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.

Re: [GENERAL] md5 hash on table row

2005-11-02 Thread Jon Lapham
Michael Fuhr wrote: test=> SELECT id, foo FROM foo; id | foo +- 1 | (1,123,"this is a test",2005-11-02,t,"\\000\\001\\002") Perfect! Wow, in all these years of using PostgreSQL,

Re: [GENERAL] md5 hash on table row

2005-11-02 Thread Michael Fuhr
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