oheinz@stud.fbi.fh-darmstadt.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