Re: array_agg and/or =ANY doesn't appear to be functioning as I expect

2018-01-21 Thread Rhys A.D. Stewart
Hannes, Thanks for your observations.. Will take a look at the data. Regards, Rhys On Jan 20, 2018 11:00 PM, "Hannes Erven" wrote: Hi Rhys, Am 2018-01-21 um 02:42 schrieb Rhys A.D. Stewart: > Greetings All, > I'm having an issue which is very perplexing. The having clause in a > quer

Re: array_agg and/or =ANY doesn't appear to be functioning as I expect

2018-01-20 Thread Hannes Erven
Hi Rhys, Am 2018-01-21 um 02:42 schrieb Rhys A.D. Stewart: Greetings All, I'm having an issue which is very perplexing. The having clause in a query doesn't appear to be working as I expect it. Either that or my understanding of array_agg() is flawed. > > [...] with listing as ( sele

array_agg and/or =ANY doesn't appear to be functioning as I expect

2018-01-20 Thread Rhys A.D. Stewart
Greetings All, I'm having an issue which is very perplexing. The having clause in a query doesn't appear to be working as I expect it. Either that or my understanding of array_agg() is flawed. I'm using PostgreSQL 10.1, compiled by Visual C++ build 1800, 64-bit. The table in question looks like: