Re: deciding on one of multiple results returned - Mailing list pgsql-sql

On Fri, Dec 21, 2012 at 10:28 AM, Wes James <comptekki@gmail.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;