Re: ALTER COLUMN/logical column position

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