Re: checksum

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;

J




> 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@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL