>"Dave [Hawk-Systems]" <dave@hawk-systems.com> writes:
>> have a data table that records entries by date(unix timestamp) and customer
>> number. each custnum will have several entries showing a running
>ledger type
>> snapshot. we have the need to get the most recent entry from not
>one, but all
>> unique customers, in the most cost effective manner.
>
>If you don't mind using a Postgres-only construct, SELECT DISTINCT ON
>is made for this. See the "weather report" example in the SELECT
>reference page.
thanks Tom, had a forest for the trees problem there and that put me on the
right track.
Dave