Postgres Pro
Downloads
Home   >   mailing lists

Re: how to use aggregate functions in this case - Mailing list pgsql-general

From Janek Sendrowski
Subject Re: how to use aggregate functions in this case
Date
Msg-id trinity-d4cabe83-9e1d-490a-ae00-bec5fec8b15a-1377555064069@3capp-webde-bs37
Whole thread Raw
In response to Re: how to use aggregate functions in this case  (David Johnston <polobo@yahoo.com>)
Responses Re: how to use aggregate functions in this case  (David Johnston <polobo@yahoo.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Problem creating index
Next
From: David Johnston
Date:
Subject: Re: how to use aggregate functions in this case