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-06 15:08:45
Message-ID: 20020306150845.39034.qmail@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.
Daniel Bortolas.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Frank Joerdens 2002-03-06 17:01:57 SELECT currval within a transaction
Previous Message Bhuvan A 2002-03-06 14:13:18 assigning values to arrays in plpgsql