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: