Postgres Pro
Downloads
Home   >   mailing lists

Re: distinct not working in a multiple join - Mailing list pgsql-general

From David Rio Deiros
Subject Re: distinct not working in a multiple join
Date
Msg-id 20060210175914.GA13242@milhouse.is04607.com
Whole thread Raw
In response to Re: distinct not working in a multiple join  (Stephen Frost <sfrost@snowman.net>)
List pgsql-general
Tree view 
On Thu, Feb 09, 2006 at 09:51:13PM -0500, Stephen Frost wrote:
> * David Rio Deiros (driodeiros@gmail.com) wrote:
> > Now I have to redefine my query because I want to get the second
> > output but keeping the group_id. Ideas and suggestions are welcome.
>
> You might want to look at 'distinct on'.

I am reading about it right now. It sounds that it will make it.

Thanks guys for your help,

David

pgsql-general by date:

Previous
From: Bob Pawley
Date:
Subject: Re: Tool
Next
From: Michael Fuhr
Date:
Subject: Re: Sequence skipping values