Re: select records by nearest value

From: e-letter <inpost(at)gmail(dot)com>
To: pgsql-novice-owner(at)postgresql(dot)org
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: select records by nearest value
Date: 2011-05-15 07:30:20
Message-ID: BANLkTin6WRAG_-W3o3MzaNTg4U+brr5_9w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Thanks, I read the link and received the following error:

ERROR: aggregates not allowed in WHERE clause

Using the example:

WHERE g1.gid = 1 and g1.gid <> g2.gid

The error occurs if the function:

=1

is replaced by:

SUM(1000)

Another question: what does '<>' mean? Couldn't find explanation in the manual.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Lew 2011-05-15 12:04:16 Re: select records by nearest value
Previous Message Joshua Tolley 2011-05-14 13:44:04 Re: More WAL archiving/backup questions