Re: [GENERAL] distinct not working in a multiple join

2006-02-10 Thread David Rio Deiros
On Thu, Feb 09, 2006 at 09:51:13PM -0500, Stephen Frost wrote: > * David Rio Deiros ([EMAIL PROTECTED]) 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'.

Re: [GENERAL] distinct not working in a multiple join

2006-02-09 Thread Stephen Frost
* David Rio Deiros ([EMAIL PROTECTED]) 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 signature.asc Description: Digital signature

Re: [GENERAL] distinct not working in a multiple join

2006-02-09 Thread David Rio Deiros
On Thu, Feb 09, 2006 at 07:20:19PM -0500, Tom Lane wrote: > David Rio Deiros <[EMAIL PROTECTED]> writes: > > I have some issues with the query attached at the end of this email. > > If I run that query I got this output ( I have removed some of the > > fields) despite the distinct clause: > > > Q

Re: [GENERAL] distinct not working in a multiple join

2006-02-09 Thread Tom Lane
David Rio Deiros <[EMAIL PROTECTED]> writes: > I have some issues with the query attached at the end of this email. > If I run that query I got this output ( I have removed some of the > fields) despite the distinct clause: > QC Q&A | www.xxx.com | 44281 > QC Q&A | www.xxx.com | 44281 > WhyMAX?