On 12/05/2010 05:57 PM, Mario Splivalo wrote:
The issue in both approaches is that if I have two product_ids that are
viewed same number of times and share the first place as most viewed
products by that user, I'll get only one of them (LIMIT 1 OR MAX() can
only return one row :).
And then, to jump again into my own mouth - your approach, Jayadevan,
correctly gives me both product_id's if they're viewed the same number
of times.
Mario
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
