> On Wed, 2011-06-29 at 11:37 -0400, Jonathan S. Katz wrote:
>> Which means it *should* work, but first I would need to clean up the data
>> and find the duplicates. I was hoping this might work:
>>
>> SELECT geocode, count(*)
>> FROM a
>> GROUP BY a.geocode
>> HAVING count(
On Wed, 2011-06-29 at 11:37 -0400, Jonathan S. Katz wrote:
> Which means it *should* work, but first I would need to clean up the data and
> find the duplicates. I was hoping this might work:
>
> SELECT geocode, count(*)
> FROM a
> GROUP BY a.geocode
> HAVING count(*) > 1
On Jun 29, 2011, at 10:42 AM, Magnus Hagander wrote:
> On Wed, Jun 29, 2011 at 16:38, Jonathan S. Katz
> wrote:
>> In fact that is my use-case - I will be performing nearest-neighbor lookups
>> (and will be running 9.1b2 on this data set shortly). However, because most
>> of the geospatial work
On Jun 29, 2011, at 10:25 AM, Magnus Hagander
wrote:
On Wed, Jun 29, 2011 at 06:53, Jeff Davis wrote:
On Tue, 2011-06-28 at 18:56 -0400, Jonathan S. Katz wrote:
I looked into the mailing list archives and found a potential answer
on this thread:
http://archives.postgresql.org/pgsql-genera
On Wed, Jun 29, 2011 at 16:38, Jonathan S. Katz
wrote:
> On Jun 29, 2011, at 10:25 AM, Magnus Hagander wrote:
>
>> On Wed, Jun 29, 2011 at 06:53, Jeff Davis wrote:
>>>
>>> On Tue, 2011-06-28 at 18:56 -0400, Jonathan S. Katz wrote:
>>>
I looked into the mailing list archives and found a pote
On Wed, Jun 29, 2011 at 06:53, Jeff Davis wrote:
> On Tue, 2011-06-28 at 18:56 -0400, Jonathan S. Katz wrote:
>
>> I looked into the mailing list archives and found a potential answer
>> on this thread:
>> http://archives.postgresql.org/pgsql-general/2009-10/msg01122.php
>> However I wanted to see
On Tue, 2011-06-28 at 18:56 -0400, Jonathan S. Katz wrote:
> I looked into the mailing list archives and found a potential answer
> on this thread:
> http://archives.postgresql.org/pgsql-general/2009-10/msg01122.php
> However I wanted to see if it was still necessary that I would need
> the comple
Hi,
I am running PostgreSQL 9.0.4 and I am getting an error with a SELECT DISTINCT
query that contains a point type in the SELECT clause. To be more specific, a
query such as:
-- explicit declaration that it's a point type
SELECT DISTINCT a.geocode::point
FROM a