On Fri, Dec 21, 2012 at 10:28 AM, Wes James <[email protected]> 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; -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
