Date: Sat, 17 Feb 2007 16:00:33 +0100
From: "A. Kretschmer" <andreas.kretschmer@schollglas.com>
To: pgsql-sql@postgresql.org
Subject: Re: sub-limiting a query
Message-ID: <20070217150033.GA30177@a-kretschmer.de>
References: <20070217125634.GA20589@apartia.fr>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20070217125634.GA20589@apartia.fr>
User-Agent: Mutt/1.5.9i

am  Sat, dem 17.02.2007, um 13:56:35 +0100 mailte Louis-David Mitterrand folgendes:
> Hello,
> 
> I've got a table of shows with different types (movie, theater, 
> 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?
> 
> The table looks basically like:
> 
> 	created_on      | timestamp without time zone 
> 	show_name       | text 
> 	id_show         | integer                     
> 	show_type       | text                        
> 	id_show_subtype | integer                     
> 

You can try to divide this into 2 selects:

First, select the last 10 entered show, this is simple.

Then, write a stored proc. Within, select for every show_type the 2 last
events.

Both results combine with UNION ALL.


I know, the hard part is the function. I havn't time at the moment to
write an example, we have guests...


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net