| From: | "yuanrui" <yuanrui(at)pset(dot)suntec(dot)net> |
|---|---|
| To: | <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Wrong result of <select distinct geometry from XXX> |
| Date: | 2016-04-06 06:04:08 |
| Message-ID: | 010101d18fca$21ac70d0$65055270$@suntec.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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.
―――――――――
袁瑞
TEL：1626
| Attachment | Content-Type | Size |
|---|---|---|
| union_test_table.zip | application/x-zip-compressed | 5.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Noah Misch | 2016-04-06 06:07:41 | Re: BUG #14050: "could not reserve shared memory region" in postgresql log |
| Previous Message | D | 2016-04-06 01:53:31 | Re: BUG #14062: pg_dump dies after dumping first 60 gigabytes of text for large table |