cannot use column references in default expression?

Поиск
Список
Период
Сортировка
От Jignesh Shah
Тема cannot use column references in default expression?
Дата
Msg-id AANLkTik7etizTd5h8sZScZc5er-XRIT-BtEga2kVQvLY@mail.gmail.com
обсуждение исходный текст
Ответы Re: cannot use column references in default expression?
Re: cannot use column references in default expression?
Список pgsql-general
Could anyone please help me to get rid of following error? I want to set the 'ishuman' column based on the value of 'ID' column but it is not allowing me to do so. Any alternatives?

techdb=> CREATE TABLE Users (
       ID INTEGER,
       isHuman        BOOLEAN NOT NULL
                      DEFAULT (ID IS NULL)
                      CHECK (isHuman = ID IS NULL),
       Name  VARCHAR NOT NULL);
ERROR:  cannot use column references in default expression
techdb=>

Thanks,
Jignesh

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