Postgres Pro
Downloads
Home   >   mailing lists

BUG #3720: wrong results at using ltree - Mailing list pgsql-bugs

From M. Palm
Subject BUG #3720: wrong results at using ltree
Date
Msg-id 200711051619.lA5GJ1h3065024@wwwmaster.postgresql.org
Whole thread Raw
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      3720
Logged by:          M. Palm
Email address:      m.palm@geoinsoft.de
PostgreSQL version: 8.2.4
Operating system:   Windows Server 2003 Web Edition
Description:        wrong results at using ltree
Details:

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.

pgsql-bugs by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: not sorted clustered index (8.2)
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #3681: fillers are NULL in pgbench