Re: distinct not working in a multiple join

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: David Rio Deiros <driodeiros(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: distinct not working in a multiple join
Date: 2006-02-10 02:51:13
Message-ID: 20060210025113.GF4474@ns.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* 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'.

Stephen

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message surabhi.ahuja 2006-02-10 03:56:51 Re: r trim of characters other than space
Previous Message Karl O. Pinc 2006-02-10 02:27:44 Re: Request to have VACUUM ignore cost based limits