Thanks. I was testing different things and I came up with something similar to that. I appreciate you taking time to
answer.<br/><br /><div class="gmail_extra"><br /><br /><div class="gmail_quote">On Fri, Dec 21, 2012 at 11:22 AM, Scott
Marlowe<span dir="ltr"><<a href="mailto:scott.marlowe@gmail.com"
target="_blank">scott.marlowe@gmail.com</a>></span>wrote:<br /><blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px#ccc solid;padding-left:1ex"><div class="im">On Fri, Dec 21, 2012 at 10:28 AM, Wes James <<a
href="mailto:comptekki@gmail.com">comptekki@gmail.com</a>>wrote:<br /> > David and Seth Thanks. That helped.<br
/>><br /> ><br /> > When I have<br /> ><br /> > select distinct on (revf3) f1, f2, f3, revers(f3) as
revf3from table order<br /> > by revf3<br /> ><br /> > Is there a way to return just f1, f2, f3 in my results
andforget revf3 (so<br /> > it doesn't show in results)?<br /><br /></div>Sure just wrap it in a subselect:<br /><br
/>select a.f1, a.f2, a.f3 from (select distinct on (revf3) f1, f2, f3,<br /> revers(f3) as revf3 from table order by
revf3)as a;<br /></blockquote></div><br /></div>