Re: Natural key woe

From: Yeb Havinga <yebhavinga(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Natural key woe
Date: 2014-05-13 15:20:12
Message-ID: 5372382C.7090406@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 13/05/14 11:44, Oliver Kohll - Mailing Lists wrote:
> The problem came when someone entered a record with no subject, but left it null. When this was copied over and present in both tables, the *next* time the join was done, a duplicate was created because the join didn't see them as matching (null != null).
Maybe you can use x IS NOT DISTINCT FROM y ?

regards,
Yeb

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2014-05-13 15:35:40 Re: better performance on poorer machine?
Previous Message Vegard Bønes 2014-05-13 14:48:16 better performance on poorer machine?