Re: cannot use column references in default expression?

On Fri, May 28, 2010 at 10:50 PM, Jignesh Shah
<jignesh(dot)shah1980(at)gmail(dot)com> wrote:
> 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
>

I don't know much about the error, but an alternative solution I see
is using Triggers. WIth triggers you can manipulate the value during
INSERT or UPDATE.

--
Nilesh Govindarajan
Facebook: nilesh.gr
Twitter: nileshgr
Website: www.itech7.com