| From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
|---|---|
| To: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
| Cc: | Hannu Krosing <hannu(at)tm(dot)ee>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Neil Conway <neilc(at)samurai(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: ALTER COLUMN/logical column position |
| Date: | 2003-11-20 13:04:56 |
| Message-ID: | 1069333496.1783.39.camel@localhost.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Which is what started the whole discussion.
Dave
On Thu, 2003-11-20 at 04:40, Andreas Pflug wrote:
> Hannu Krosing wrote:
>
> >
> >attnum is used internally to retrieve the data
> >
> >
> >
> Oops...
>
> So if an additional column number is invented, it should not be a
> logical column number, but a physical storage number for internal data
> retrieval. This way, the "user interface" doesn't change, and all those
> "SELECT ... FROM pg_attribute ORDER BY attnum" continue delivering the
> expected result.
>
> Regards,
> Andreas
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Manfred Koizar | 2003-11-20 13:33:04 | Re: logical column position |
| Previous Message | Hannu Krosing | 2003-11-20 13:04:17 | Re: ALTER COLUMN/logical column position |