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