John Beynon <john@xxxxxxxx> writes: > I have a pretty basic query; > select distinct on (name) name, length(name) from > drugs > where customer_id IS NOT NULL > order by name; > which I'd expect to only return me a single drug name if there are > duplicates, yet I get > name | length > ========== > Roaccutane | 10 > Roaccutane | 10 > table encoding is UTF8... > I'm scratching my head! Yeah, me too. What PG version is this exactly? What does EXPLAIN show for the query? Can you extract a self-contained test case? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
