if you have these tuples in your database:

a b c

1 1 r

1 2 e

2 3 t

4 2 s

SELECT DISTINCT ON (a) a, b, c will return:

a b c

1 1 r

2 3 t

4 2 s