Re: distinct not working in a multiple join

From: David Rio Deiros <driodeiros(at)gmail(dot)com>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: distinct not working in a multiple join
Date: 2006-02-10 17:59:14
Message-ID: 20060210175914.GA13242@milhouse.is04607.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Feb 09, 2006 at 09:51:13PM -0500, Stephen Frost wrote:
> * David Rio Deiros (driodeiros(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2006-02-10 18:03:57 Re: Tool
Previous Message Steve Crawford 2006-02-10 17:57:31 Re: Sequence skipping values