Skip site navigation (1) Skip section navigation (2)

Re: checksum

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: David Helgason <david(at)uti(dot)is>
Cc: Federico Balbi <fbalbi(at)cs(dot)utsa(dot)edu>,postgresql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: checksum
Date: 2004-09-26 18:21:23
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
David Helgason wrote:

>>   I was wondering if PGSQL has a function similar to 
>> binary_checksum() of
>> MS SQL Server 2000. It is pretty handy when it comes to compare rows of
>> data instead of having to write long boolean expressions.
>> binary_checksum() takes a list of fields and it returns an integer value
>> which sumarize the row content.
You could use the md5 function.... such as :

select md5(foo) from bar where baz = 2;


> On a similar note, I've found myself wanting an extended '=' operator 
> meaning
>     (a = b or (a is null and b is null))
> same goal of course, for more general comparisons...
> d.

Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com -
PostgreSQL Replicator -- production quality replication for PostgreSQL

In response to


pgsql-general by date

Next:From: Federico BalbiDate: 2004-09-26 18:31:36
Subject: Re: checksum
Previous:From: David HelgasonDate: 2004-09-26 18:16:52
Subject: Re: checksum

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group