Re: Selecting distinct records

>"Dave [Hawk-Systems]" <dave(at)hawk-systems(dot)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