From: | Lew <noone(at)lewscanon(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: select records by nearest value |
Date: | 2011-05-15 12:04:16 |
Message-ID: | iqoffk$8di$1@news.albasani.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 05/15/2011 03:30 AM, e-letter wrote:
> 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)
That's because SUM() is an aggregate function - it collects information over a
query or GROUP BY. WHERE clauses operate on values from single records. You
can get the effect with a correlated subquery, perhaps.
> Another question: what does '<>' mean? Couldn't find explanation in the manual.
Go to the manual
<http://www.postgresql.org/docs/9.0/interactive/>
Click on chapter 9, "Functions and Operators".
<http://www.postgresql.org/docs/9.0/interactive/functions.html>
Click on chapter 9.2, "Comparison Operators".
<http://www.postgresql.org/docs/9.0/interactive/functions-comparison.html>
--
Lew
Honi soit qui mal y pense.
http://upload.wikimedia.org/wikipedia/commons/c/cf/Friz.jpg
From | Date | Subject | |
---|---|---|---|
Next Message | sanal mk | 2011-05-19 10:29:10 | error in server connection |
Previous Message | e-letter | 2011-05-15 07:30:20 | Re: select records by nearest value |