Postgres Pro
Downloads
Home   >   mailing lists

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

From Stephen Frost
Subject Re: distinct not working in a multiple join
Date
Msg-id 20060210025113.GF4474@ns.snowman.net
Whole thread Raw
In response to Re: distinct not working in a multiple join  (David Rio Deiros <driodeiros@gmail.com>)
Responses Re: distinct not working in a multiple join  (David Rio Deiros <driodeiros@gmail.com>)
List pgsql-general
Tree view 
* 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'.

    Stephen
Attachment

pgsql-general by date:

Previous
From: "Karl O. Pinc"
Date:
Subject: Re: Request to have VACUUM ignore cost based limits
Next
From: "surabhi.ahuja"
Date:
Subject: Re: r trim of characters other than space