problem with distinct not distincting...

Поиск
Список
Период
Сортировка
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!

Thanks,

John.


В списке pgsql-general по дате отправления:

Предыдущее
От: "amitkapila [via PostgreSQL]"
Дата:
Сообщение: Re: How to avoid base backup in automated failover
Следующее
От: "chinnaobi [via PostgreSQL]"
Дата:
Сообщение: Re: How to avoid base backup in automated failover