John Beynon <j...@kyan.com> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
