Louis-David Mitterrand <[EMAIL PROTECTED]> schrieb: > ballet,etc.) and I am looking for a select that can return the 10 last > entered shows AND at most 2 of each type. Is that possible in one query?
A similar question i found in the archive and there are a couple of answers: (for the second part of your question) http://archives.postgresql.org/pgsql-sql/2005-03/msg00408.php But as i said, there is no plain sql-solution. Unfortunately we haven't windowing functions, but perhaps in the future, Gavin Sharry is working on this. Take a look at http://www.gavinsherry.org/blog/index.php?/archives/7-Window-function-presentation.html Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknow) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
