Re: Adding UNIQUE constraint on NULL column - Mailing list pgsql-general

On Thu, 2005-01-13 at 11:02, Doug McNaught wrote:
> Dave Smith <dave.smith@candata.com> writes:
>
> > On Thu, 2005-01-13 at 10:12, Doug McNaught wrote:
>
> >> Are you really saying that you want 'NULL = NULL' to return 't'?
>
> > Yes
>
> Well, that's not how NULL works.

In this instance, just create an artificial NULL, like a text string of
"NONE" and insert that.