Re: Problem using Subselect results

oheinz(at)stud(dot)fbi(dot)fh-darmstadt(dot)de writes:
> But as this data is time sensitive, we introduce some kind of time stamp - a
> serial which is global to all tables. Now, for each record in table 'one' i
> want to see only the corresponding records in tables two, three, etc... that
> were created before 'one.updatenr'

> SELECT * FROM one, two WHERE (one.two_id=two.two_id AND one.updatenr >
> two.updatenr);

> This might match multiple records in tables two (two_id is not a pk, we have
> historic records in this table). Now I want only the most current version
> before one.updatenr. - And that's where I run into trouble.

You might be able to make this work by using SELECT DISTINCT ON. See
the "weather reports" example in the SELECT reference page.

regards, tom lane