From: A. Kretschmer <andreas.kretschmer@schollglas.com>
To: pgsql-sql@postgresql.org
Subject: Re: sub-limiting a query
Date: Sat, 17 Feb 2007 16:00:33 +0100
Message-ID: <20070217150033.GA30177@a-kretschmer.de> (raw)
In-Reply-To: <20070217125634.GA20589@apartia.fr>
References: <20070217125634.GA20589@apartia.fr>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: andreas.kretschmer@schollglas.com
Subject: Re: sub-limiting a query
In-Reply-To: <20070217150033.GA30177@a-kretschmer.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox