Alban Hertroys wrote on 08.08.2010 10:46:
On 7 Aug 2010, at 23:18, Thomas Kellerer wrote:Or as an alternative: SELECT tid, purchase_date FROM orders WHERE item in ('Laptop', 'Desktop') GROUP BY tid, purchase_date HAVING count(*) = 2This one is incorrect, it will also find people who bought two laptops or two desktops on the same date.
Right. I didn't think about that ;)
But I think David's solution is more readable, as it leaves the item names in tact.
I absolutely agree. Another example of PG's cool array handling :) Regards Thomas -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
