Hi,
I did the following:
CREATE TABLE data (id SERIAL, title VARCHAR);
CREATE TABLE data_copy(id INT4, title VARCHAR);
CREATE RULE make_copy AS ON INSERT TO data DO INSERT INTO data_copy
(id,title) VALUES (NEW.id, NEW.title);
INSERT INTO data (title) VALUES ('test');
database=# SELECT * FROM dat
I think I found a bug in the ltree module. The following query should
return false but I get true.
SELECT '5.0.1.0'::ltree ~ '5.!0.!0.0'::lquery
I get the same result with the 'ltree.dll' of PostgreSQL 8.2.5. If you
have a solution of the problem I would be very happy.
-
