simple problem - Mailing list pgsql-sql

From Daniel Ordobas Bortolas
Subject simple problem
Date
Msg-id 20020306150845.39034.qmail@inf.ufsm.br
Whole thread Raw
Responses Re: simple problem  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: simple problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: simple problem  (Masaru Sugawara <rk73@sea.plala.or.jp>)
List 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.


pgsql-sql by date:

Previous
From: Bhuvan A
Date:
Subject: assigning values to arrays in plpgsql
Next
From: Frank Joerdens
Date:
Subject: SELECT currval within a transaction