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