From:
Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To:
Matteo Beccati <php(at)beccati(dot)com>
Cc:
Aidan Van Dyk <aidan(at)highrise(dot)ca>, Magnus Hagander <magnus(at)hagander(dot)net>, Dave Page <dpage(at)pgadmin(dot)org>, Abhijit Menon-Sen <ams(at)toroid(dot)org>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Tim Bunce <Tim(dot)Bunce(at)pobox(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: mailing list archiver chewing patches
Date:
2010-01-14 14:47:02
Message-ID:
87r5ps7nh5.fsf@hi-media-techno.com (view raw or flat )
Thread:
2010-01-08 23:51:42 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-01-09 04:56:06 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-01-09 05:17:27 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-01-09 22:27:48 from Tim Bunce <Tim(dot)Bunce(at)pobox(dot)com>
2010-01-09 22:42:54 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-01-10 09:27:21 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-11 00:18:22 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-01-11 09:46:10 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-11 13:23:31 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-11 13:50:36 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-11 14:00:03 from Abhijit Menon-Sen <ams(at)toroid(dot)org>
2010-01-11 22:23:41 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-12 04:54:03 from Dave Page <dpage(at)pgadmin(dot)org>
2010-01-12 09:05:56 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-12 09:30:41 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-12 19:56:29 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-12 20:04:27 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-12 20:37:50 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-12 20:16:47 from Aidan Van Dyk <aidan(at)highrise(dot)ca>
2010-01-12 21:28:03 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-12 21:33:38 from Aidan Van Dyk <aidan(at)highrise(dot)ca>
2010-01-12 22:10:57 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-14 07:22:29 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-14 12:23:31 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-14 13:39:44 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-14 13:46:09 from Dave Page <dpage(at)pgadmin(dot)org>
2010-01-14 14:32:13 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-14 14:36:35 from Dave Page <dpage(at)pgadmin(dot)org>
2010-01-14 14:08:22 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-14 14:47:02 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-14 15:06:33 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-14 15:09:43 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-14 18:36:09 from David Fetter <david(at)fetter(dot)org>
2010-01-15 19:38:50 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-16 10:48:50 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-16 13:21:58 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-18 14:48:12 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-18 14:55:00 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-18 15:19:36 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-18 17:35:07 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-18 17:44:28 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-18 15:52:49 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-01-18 17:31:08 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-18 17:42:48 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-19 08:11:32 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-19 08:44:01 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-30 16:08:08 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-30 16:54:37 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-01-30 21:43:50 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-31 12:45:09 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-31 14:09:17 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-31 17:51:10 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-30 21:14:10 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-30 21:18:48 from Joe Conway <mail(at)joeconway(dot)com>
2010-01-31 12:38:11 from Matteo Beccati <php(at)beccati(dot)com>
2010-02-01 02:27:24 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-02-01 08:06:14 from Matteo Beccati <php(at)beccati(dot)com>
2010-02-01 09:26:04 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-02-01 13:36:21 from Matteo Beccati <php(at)beccati(dot)com>
2010-02-01 14:03:52 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-02-01 14:10:14 from Matteo Beccati <php(at)beccati(dot)com>
2010-02-01 14:16:44 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-02-01 16:28:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-01 16:31:21 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-01 16:41:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-01 16:43:31 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-01 18:50:22 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-02-13 12:34:56 from Matteo Beccati <php(at)beccati(dot)com>
2010-05-01 18:16:13 from Matteo Beccati <php(at)beccati(dot)com>
2010-05-01 18:19:22 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-05-03 16:07:25 from Selena Deckelmann <selenamarie(at)gmail(dot)com>
2010-05-03 16:32:11 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-05-03 16:35:32 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-05-03 16:55:39 from Matteo Beccati <php(at)beccati(dot)com>
2010-11-21 20:06:23 from David Fetter <david(at)fetter(dot)org>
2010-11-22 00:39:38 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-11-22 04:48:14 from Matteo Beccati <php(at)beccati(dot)com>
2010-11-24 13:33:20 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-24 14:51:55 from Matteo Beccati <php(at)beccati(dot)com>
2010-11-22 05:08:59 from Rob Wultsch <wultsch(at)gmail(dot)com>
2010-05-23 16:33:34 from Matteo Beccati <php(at)beccati(dot)com>
2010-06-07 14:35:48 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-06-07 16:21:37 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-12 16:38:00 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2010-01-12 16:54:51 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-12 17:34:45 from Dave Page <dpage(at)pgadmin(dot)org>
2010-01-12 18:54:27 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-12 19:58:09 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-12 17:38:13 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2010-01-12 09:33:46 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-11 10:18:47 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-11 11:53:08 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-11 11:58:20 from Dave Page <dpage(at)pgadmin(dot)org>
2010-01-11 13:13:47 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-11 13:24:58 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-11 13:35:07 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-11 14:20:19 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-01-10 01:15:23 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Lists:
pgsql-hackers pgsql-www
Matteo Beccati <php(at)beccati(dot)com> writes:
> WITH RECURSIVE t (mailbox, uid, date, subject, sender, has_attachments,
> parent_uid, idx, depth) AS (
> SELECT mailbox, uid, date, subject, sender, has_attachments, parent_uid,
> uid::text, 1
> FROM arc_messages
> WHERE parent_uid IS NULL AND mailbox = 15
> UNION ALL
> SELECT a.mailbox, a.uid, a.date, a.subject, a.sender, a.has_attachments,
> a.parent_uid, t.idx || '.' || a.uid::text, t.depth + 1
> FROM t JOIN arc_messages a USING (mailbox)
> WHERE t.uid = a.parent_uid
> ) SELECT * FROM t ORDER BY idx
>
> Any improvements to sorting are welcome :)
What I'd like would be to have it sorted by activity, showing first the
thread which received the later messages. I'm yet to play with CTE and
window function myself so without a database example to play with I
won't come up with a nice query, but I guess a more educated reader will
solve this without a sweat, as it looks easier than sudoku-solving,
which has been done already :)
Regards,
--
dim
In response to
Responses
pgsql-www by date
Next :From: Matteo BeccatiDate: 2010-01-14 15:06:33Subject : Re: mailing list archiver chewing patchesPrevious :From : Dave PageDate : 2010-01-14 14:36:35Subject : Re: mailing list archiver chewing patches
pgsql-hackers by date
Next :From: Pavel StehuleDate: 2010-01-14 14:53:29Subject : Re: [PL/PgSQL] EXECUTE...USING enhancement proposalPrevious :From : Vincenzo RomanoDate : 2010-01-14 14:44:20Subject : [PL/PgSQL] EXECUTE...USING enhancement proposal
