Re: deciding on one of multiple results returned

Thanks. I was testing different things and I came up with something
similar to that. I appreciate you taking time to answer.

On Fri, Dec 21, 2012 at 11:22 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>wrote:

> On Fri, Dec 21, 2012 at 10:28 AM, Wes James <comptekki(at)gmail(dot)com> wrote:
> > David and Seth Thanks. That helped.
> >
> >
> > When I have
> >
> > select distinct on (revf3) f1, f2, f3, revers(f3) as revf3 from table
> order
> > by revf3
> >
> > Is there a way to return just f1, f2, f3 in my results and forget revf3
> (so
> > it doesn't show in results)?
>
> Sure just wrap it in a subselect:
>
> select a.f1, a.f2, a.f3 from (select distinct on (revf3) f1, f2, f3,
> revers(f3) as revf3 from table order by revf3) as a;
>