Re: Best way to "add" columns

Martijn van Oosterhout <kleptog@cupid.suninternet.com>

From: Martijn van Oosterhout <kleptog@cupid.suninternet.com>
To: Marten Feldtmann <marten@feki.toppoint.de>
Cc: Jesse Scott <jscott@bmi.net>, pgsql-general@postgresql.org
Date: 2000-05-15T14:15:43Z
Lists: pgsql-general
Marten Feldtmann wrote:
> 
>  The varable lengths columns should be at the end of the row, therefore
>  it does not seem to be good to add an integer column after a varchar
>  column.

1. Is this true? Should variable length column really be at the end
of a row?

2. If so, surly postgres can reorder tham internally so that on disk
they are in the optimal format.
-- 
Martijn van Oosterhout <kleptog@cupid.suninternet.com>
http://cupid.suninternet.com/~kleptog/