From: | David Johnston <polobo(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: how to use aggregate functions in this case |
Date: | 2013-08-27 01:15:26 |
Message-ID: | 1377566126903-5768636.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Janek Sendrowski wrote
> Hi,
>
>
>
> thanks for all your answers.
>
> I'll have a try with the contains operator and the intrange, but
> before I'd like to know if this would work:
>
>
>
> CASE WHEN a >= 0 AND a < 25
>
> CASE WHEN a >= 25 AND a < 50
>
>
>
> There wouldn't be a double endpoint. I just have to decide which range
> the endpoint includes.
>
>
>
> Janek Sendrowski
Yes, using explicit comparison operators with "AND" will work just fine; its
just a little more verbose so the other options, if available, are preferred
from a readability standpoint. I do not know whether the different options
may have different performance characteristics.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/how-to-use-aggregate-functions-in-this-case-tp5768522p5768636.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | BladeOfLight16 | 2013-08-27 01:31:40 | Re: Please help me regarding the WITH RECURSIVE query |
Previous Message | Janek Sendrowski | 2013-08-26 22:11:04 | Re: how to use aggregate functions in this case |