Re: [SQL] using LIMIT only on primary table

2002-07-29 Thread Lee Harr
In article <3D42D7AA.27447.3EE190A0@localhost>, "Dan Langille" wrote: > This is an extension of the problem solved by > http://archives.postgresql.org/pgsql-sql/2002-03/msg00020.php but > with a slightly different complication. > > I want to get the last 100 port commits from the database. Com

[SQL] using LIMIT only on primary table

2002-07-27 Thread Dan Langille
This is an extension of the problem solved by http://archives.postgresql.org/pgsql-sql/2002-03/msg00020.php but with a slightly different complication. I want to get the last 100 port commits from the database. Commits are stored in commit_log and commit_log_ports relates commits to ports.