| From: | David Helgason <david(at)uti(dot)is> |
|---|---|
| To: | Federico Balbi <fbalbi(at)cs(dot)utsa(dot)edu> |
| Cc: | postgresql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: checksum |
| Date: | 2004-09-26 18:16:52 |
| Message-ID: | 3DB1DC3E-0FE8-11D9-A386-000A9566DA8A@uti.is |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> 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.
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.
--
David Helgason,
Business Development et al.,
Over the Edge I/S (http://otee.dk)
Direct line +45 2620 0663
Main line +45 3264 5049
On 26. sep 2004, at 19:58, Federico Balbi wrote:
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2004-09-26 18:21:23 | Re: checksum |
| Previous Message | Federico Balbi | 2004-09-26 17:58:55 | checksum |