simple problem

From: Daniel Ordobas Bortolas <bortolas(at)inf(dot)ufsm(dot)br>
To: pgsql-sql(at)postgresql(dot)org
Subject: simple problem
Date: 2002-03-05 11:44:58
Message-ID: Pine.A41.4.05.10203050836490.34602-100000@onix.inf.ufsm.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hello!
I am having problems creating a table and i'd like some help.

-->create table loco( id_loco int4 not null, primary key (id_loco), check(
(select count(*) from loco ) < 3 ) );

I guess the statment is right, but when:
->insert into loco values(1);

the result is: ERROR: ExecEvalExpr: unknown expression type 108

How can I fix this problem?

Thanks.

Browse pgsql-sql by date

  From Date Subject
Next Message Ismail Bouabdallah 2002-03-05 14:32:37 function error: ERROR:   fmgr_info: function 56664: cache lookup failed
Previous Message Matteo Beccati 2002-03-05 08:13:16 Re: thinking about versioning my database schema