Re: Adding UNIQUE constraint on NULL column

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Adding UNIQUE constraint on NULL column
Дата
Msg-id 1105647399.24795.97.camel@state.g2switchworks.com
обсуждение исходный текст
Ответ на Re: Adding UNIQUE constraint on NULL column  (Doug McNaught <doug@mcnaught.org>)
Ответы Re: Adding UNIQUE constraint on NULL column  ("Frank D. Engel, Jr." <fde101@fjrhome.net>)
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Lonni J Friedman
Дата:
Сообщение: Re: allowing connections from additional hosts without a restart?
Следующее
От: "Woody Woodring"
Дата:
Сообщение: Re: allowing connections from additional hosts without a restart?