some problems

Ahoy!

Hi!
I have the following table:

create table address
(
id int4 primary key,
owner int4 not null,
content varchar(80) not null
CHECK (owner in (select id from id where t_name in ('org',
'person',
'router', 'dns')))
);
create trigger delete_id before delete
on address for each row execute procedure delete_id();
create trigger set_id before insert
on address for each row execute procedure set_id();

Everything seems OK, but when I type this:

ripv=# insert into address values(0, 18, 'Szeged');

I get an error:

ERROR: ExecEvalExpr: unknown expression type 108

But these queries work:

ripv=# select 18 in (select id from id where t_name in ('org', 'person',
'router', 'dns'));
?column?
----------
t
(1 row)

ripv=# select id from id where t_name in ('org', 'person', 'router',
'dns');
id
----
5
18
(2 rows)

ripv=#

Any comment?

--
Roodie ICQ: 53623985
Linux, C++, VB, SQL, PhotoShop, Lightwave
Ars Magica, AD&D, Mutant Chronicles