On Thu, Aug 20, 2009 at 11:24:49AM +0200, vinny wrote: > I can't really think of any real reason to put the field at a > particular position, applications don't reallty care about the order > of fields.
Because it's very convenient for ad-hoc queries! PG currently assumes that the column order is the same as when it was created but there are (unimplemented) suggestions about how to "fix" this. See for example: http://archives.postgresql.org/pgsql-hackers/2006-12/msg00983.php -- Sam http://samason.me.uk/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
