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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
