On Fri, May 28, 2010 at 10:50 PM, Jignesh Shah <jignesh.shah1...@gmail.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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
