Re: how to use aggregate functions in this case

From: "Janek Sendrowski" <janek12(at)web(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: how to use aggregate functions in this case
Date: 2013-08-26 22:11:04
Message-ID: trinity-d4cabe83-9e1d-490a-ae00-bec5fec8b15a-1377555064069@3capp-webde-bs37
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>
<div>Hi,</div>

<div>&nbsp;</div>

<div>thanks for all your answers.</div>

<div>I&#39;ll have a try with the contains operator and the intrange, but before I&#39;d like to know if this would work:</div>

<div>&nbsp;</div>

<div>CASE WHEN a &gt;= 0 AND a &lt;&nbsp;25</div>

<div>CASE WHEN a &gt;=&nbsp;25 AND a &lt; 50</div>

<div>&nbsp;</div>

<div>There wouldn&#39;t be a double endpoint. I just have to decide which range the endpoint includes.</div>

<div>&nbsp;</div>

<div>Janek Sendrowski</div>
</div></div></body></html>

Attachment Content-Type Size
unknown_filename text/html 616 bytes

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2013-08-27 01:15:26 Re: how to use aggregate functions in this case
Previous Message Jeff Janes 2013-08-26 18:41:02 Re: Problem creating index