Обсуждение: Index not used on a DISTINCT ON

Hi all,

I have a table with two column:   id_user and login;

and the column login is a Primary Key.

If I made the following view:
CREATE VIEW foo
    SELECT DISTINCT ON ( login )
        ul.id_login       AS login,
        ud.last_name  AS last_name,
    FROM user_login ul LEFT JOIN v_user_traffic v USING ( id_user)
                user_data ud
   WHERE  ul.id_user = ud.id_user;

when is used in this way:

    SELECT * FROM foo WHERE login = 'XXXXXX';

the index is not used if I remove the DISTINCT ON
the filter is used!!!

Is it a known issue ?

"Gaetano Mendola" <mendola@bigfoot.com> writes:
> the index is not used if I remove the DISTINCT ON
> the filter is used!!!
> Is it a known issue ?

Okay, okay already ;-)

This has been on my to-fix list for awhile.  It's fixed now for 7.4.

            regards, tom lane