Re: pg_attribute.attnum - wrong column ordinal?

Oops, the server that I thought was 8.3 was recently upgraded to 8.4.

I'm going to generate the ordinals on the client then. The nature of the
query is that it can request columns information for all or several tables
as well. The ordinals generation algorithm can reset counter to 1 each time
the table name changes.

Thank you tons!

On Tue, Nov 24, 2009 at 8:04 PM, Greg Stark <gsstark(at)mit(dot)edu> wrote:

> 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
>