Re: Problem using Subselect results - Mailing list pgsql-sql

Oliver,

> SELECT DISTINCT ON (two.two_id) two.two_value FROM one,two WHERE
> (one.two_id=two.two_id
> AND one.updatenr > two.updatenr) ORDER BY two.updatenr ASC;

FWIW, SELECT DISTINCT ON () is slower than SELECT .... ORDER BY ... LIMIT 1 on
all stable versions of Postgres.   Not that the LIMIT 1 method can be used
with all queries.

--
-Josh BerkusAglio Database SolutionsSan Francisco