| From: | yuan_rui1987(at)126(dot)com |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #14067: Wrong result of <select distinct geometry from XXX> |
| Date: | 2016-04-06 06:10:38 |
| Message-ID: | 20160406061038.15199.13220@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14067
Logged by: rui.yuan
Email address: yuan_rui1987(at)126(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Schuch, Mathias (Mathias) | 2016-04-06 09:07:05 | Re: BUG #14050: "could not reserve shared memory region" in postgresql log |
| Previous Message | Noah Misch | 2016-04-06 06:07:41 | Re: BUG #14050: "could not reserve shared memory region" in postgresql log |