BUG #14067: Wrong result of - Mailing list pgsql-bugs

From	yuan_rui1987@126.com
Subject	BUG #14067: Wrong result of
Date	April 6, 2016 22:54:54
Msg-id	20160406061038.15199.13220@wrigleys.postgresql.org Whole thread Raw
Responses	Re: BUG #14067: Wrong result of
List	pgsql-bugs

Tree view

The following bug has been logged on the website:

Bug reference:      14067
Logged by:          rui.yuan
Email address:      yuan_rui1987@126.com
PostgreSQL version: 9.5.0
Operating system:   windows 7
Description:

Hi,

Sorry to bother.
I have encountered the following problem, please help me.

The attached file is a backup file of two geometries, the table name is
<temp_union_test>, the column of geometry is <the_geom>.
when I execute < select distinct the_geom from temp_union_test >, there is
only one row returned, but actually, the two geometries is totally
different.
I have tried this execution on PostgreSql 9.0 and PostgreSql 9.5, the
results is always the same.

Would you help me to solve this problem?
If you have any concern about it, I would be very appreciate it.
Thank you.

pgsql-bugs by date:

Previous

From: "yuanrui"
Date: 06 April 2016, 22:54:50
Subject: Wrong result of