Re: Selecting distinct records

>"Dave [Hawk-Systems]" <dave@hawk-systems.com> writes:
>>> What I am looking to do is
>>> - grab every record for $user
>>> - remove any records that have identical ipaddress+sessionid+refid
>>> - then sort the results by date_time or something else
>
>> this last requirement is where the problem is...
>
>I think you need two levels of select.  To do the DISTINCT ON you must
>sort by the columns to be distinct'd.  You can re-sort the result in
>an outer select.  For example:
>
>select * from
>  (select distinct on (ten) * from tenk1 order by ten) ss
>order by hundred;

is this vailable in 7.0.3, I get an error at the second select

Dave