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;