select distinct - Mailing list pgsql-general

From newsreader@mediaone.net
Subject select distinct
Date
Msg-id 20010812203935.A29686@dragon.universe
Whole thread Raw
Responses Re: select distinct  (newsreader@mediaone.net)
List pgsql-general
It seems that I cannot get other columns
with distinct in the select statement.

I want to do like
    select distinct i,a from a where c=2;

Right now I have to do
    select distinct i from a where c=2
and then iterate over each i to get a

I have also tried
    select a,distinct i from a where c=2

I would appreciate any suggestion

Thanks


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgresQL setup in hosted environment
Next
From: newsreader@mediaone.net
Date:
Subject: Re: select distinct