On Wed, Nov 25, 2009 at 2:00 AM, Konstantin Izmailov <pgfizm(at)gmail(dot)com> wrote:
> Greg,
> this is brilliant - thank you very much!
>
> Is "partition by" compatible to PostgreSQL 8.0/8.2? I could not find
> compatibility information. It works fine with PG 8.3/8.4 and Greenplum 3.3
> thou.
It's 8.4 only.
You could also just generate them on the client since the ordering the
query requests is the right order for it.
--
greg